Hi.

im working on a work sheet that has One Summary Sheet with 20+ Subsheets.

On the summary sheet, i need to be able pull data from cell D31 on Sheet1 and display on Summary sheet cell B3.
On the Next sheet i will still pull data from D31 on Sheet2 and Display on Summary Sheet Cell B4
but i want to be able to do this without manually changing Sheet1 to Sheet2 etc and changing summary sheet ref from b3 to b4. (i.e. a drag down system as there maybe up to 30 or 40 Sheets)

Also Is there a way to preset name of new Sheet when i am making a copying of Sheet1 as the template on sheet1 and sheet 2 are the same.