Copy same cell in multiple worksheets onto one worksheet

[Tia]

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???

 

[Pete_UK]

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