Copy same cell in multiple worksheets onto one worksheet
 

I have the following worksheets: May 1, June 6, July 9.

I want the cell B4 from each of these worksheets to fill in a column on a
new worksheet labeled date. Then I need cell G15 from each worksheet filled
in under a column labeled results. What would be the best way to go about
this???

Copy same cell in multiple worksheets onto one worksheet
 

I would list the worksheet names (exactly as they appear on the tabs)
in a column somewhere on the Date sheet. Suppose this is in L4
downwards. Then in A2 (say) you can have this formula:

=INDIRECT("'"&L4&"'!B4")

and this one in B2:

=INDIRECT("'"&L4&"'!G15")

Then you can copy these two down for as many sheets as you have in
column L.

Hope this helps.

Pete

On Sep 16, 11:02*pm, Tia wrote:
I have the following worksheets: *May 1, June 6, July 9.

I want *the cell B4 from each of these worksheets to fill in a column on a
new worksheet labeled date. *Then I need cell G15 from each worksheet filled
in under a column labeled results. *What would be the best way to go about
this???