Pull a value from another worksheet

[brianelowry]

I've created a workbook with 12 worksheets in it. Each sheet represents
a month, and on each sheet there is a value of hours on each one that
represents overtime hours per month.
I'm wanting to create a "summary" page that will pull the overtime
value out of a cell on each sheet and put it on the summary page.
Is there a simple way to do this?

Thanks in advance.

 

[Bob Phillips]

Put the sheet names in A1:A12, then in B1 enter

=INDIRECT("'"&A1&"'!A1")

and copy down.

This assumes that the value to be retrieved is in A1 on each sheet.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[brianelowry]

Worked like a charm. Thanks

Put the sheet names in A1:A12, then in B1 enter

=INDIRECT("'"&A1&"'!A1")

and copy down.

This assumes that the value to be retrieved is in A1 on each sheet.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)