How do I copy text and values from the same workbook onto a different sheet??

[kepcopower]

Hi guys:

I have a commissions workbook with about 20-30 sheets. In A1 of every
sheet is a Name and in column G is a bunch of Numerical Values. I want
to create a "Grand Total" sheet where I have the Name and the Values
corresponding from each of the sheets onto my final one. Any help
would be appreciated.

 

[kjcramp]

Sounds like you need to create a link between the individual worksheets
and the grand total sheet. From the GT sheet, enter the = sign, then
tab to the a1 name from the first individual sheet (I'm assuming you
want to list each name on the GT). Repeat for each name, creating a
column of links for the names. Repeat for a GT total, using the
individual totals from each page.

 

[kepcopower]

Sounds like you need to create a link between the individual worksheets
and the grand total sheet. From the GT sheet, enter the = sign, then
tab to the a1 name from the first individual sheet (I'm assuming you
want to list each name on the GT). Repeat for each name, creating a
column of links for the names. Repeat for a GT total, using the
individual totals from each page.

Is there a formula way rather than going back and forth through 20-30
sheets. I have 3 workbooks I have to do this on, so I have close to
100 worksheets to deal with.