Summary Sheet shows content from other worksheets (Excel 2003)

I have an Excel workbook containing four worksheets and I want to place on one of the sheets name "Summary" the content from the other three sheets such as Sheet 1, followed vertically by Sheet2, then sheet 3. Is there some built in methiod to link the sheets together. The column headers for the three sheets are the same so repeating the headers is not required.

Re: Summary Sheet shows content from other worksheets (Excel 2003)

No builtin way. A simple way is to just use copy and paste from each sheet

I would then delete the original sheets, I see no need to keep multiple copies of the same data. Using the combined allows much easier manipulation and the use of built-in routines (filtering, pivot tables, etc)
Steve

Re: Summary Sheet shows content from other worksheets (Excel 2003)

I don't think there's a standard built-in method. You can copy ranges, then use Edit | Paste Special... on the summary sheet and click Paste Link to create a link to the original data. If you edit cells in one of the three source sheets, the corresponding cells in the summary sheet will be updated automatically. But the link formulas don't handle insertion or deletion of cells.