Want to create a summary page in excel 1

[MJamison07]

In column A, I used a macro I found on tek-tips to list all of the tab names in the workbook. worked Great!! Next to the name of each sheet in column A I want the contents of cell C66 of that sheet in column B.

Col A ColB
1 Sheet1 Contents of C66 from Sheet1

I can create a formula to do it, but I have to go to each sheet and click on C66. I have 50 sheets in the workbook. Any way I can automate it?

Thanks
MJamison

 

[kpetursson]

use this formula in B1
=INDIRECT(A1 & "!C66")
You can then copy it down.

Kevin Petursson

 

[MJamison07]

That was the ticket - Thank you!!