My question can best be explained by using an example:

I have several worksheets with the same format labeled "week 1" through
"week 52" in sequential order. I have another worksheet with the same column
headings as the previous mentioned worksheets. I want to link a cell from
each "week #" worksheet to the summary worksheet in sequential cells.
Basically summarizing data to a single worksheet. I know I can individually
link the cells from each separate worksheet but isn't there an easier way?
Thanks, I appreciate everyone's input.