Make cells in Summary sheet equal SAME cell in DIFFERENT places on other respective sheets

[AndrewRZ]

I apologize for not making my Title more clear and descriptive, sometimes I am not the best with words..............

But, this is what I am trying to accomplish: I have created a Time Sheet Template. There is a different worksheet for each week, as well as a SUMMARY worksheet. Within the SUMMARY worksheet I have a column for 'Subtotals'. I want the cells in this column to equal the Subtotal for their respective week.
E.g. SUMMARY worksheet Row 1: Week 1
SUMMARY worksheet Row 2: Week 2
etc.

My issue arises from the fact that the Subtotal cell is not located in the same position (i.e Row, Column) on each separate worksheet. I was thinking of recording a macro where I use keyboard shortcuts to flip between the different worksheets and then search for 'Subtotal', move the cursor one cell to the right, etc. but I still do not know how to alter the macro so that it would go to the subsequent sheet.

Again, I apologize if this does not make much sense. But, if you think you do understand what I am asking, please HELP!!!. I have spent way too much time on this already.
Thanks.

[ragulduy]

you can tell it to move through the workbook using something like:

Please Login or Register  to view this content.

It's pretty difficult to provide any more advice without any clue as to what your workbook looks like. I'd guess you could probably do this with formulas to find where the subtotal column is though.

[JOHN H. DAVIS]

Can you attach a sample workbook with some dummy data? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.