Excel Getting info from multiple sheets

[Sl33py]

Hi
I have different sheets, each sheet is an invoice. Then I have a summary sheet.
The summary sheet got the date, invoice number, customer name, amount ext
It needs to pull the info from each sheet and put it in the summary sheet on separate rows
One invoice details will be displayed in one row in different column

I can do the first line fine {='5000'!$F$4} I want to be able to drag this formula down the rows to automatically change the sheet numbers 5001, 5002, 5003
How do I do it or do I use another formula? The customer computer limit is very limited so I can’t use high end stuff.

Thanks

 

[Drake2007]

=INDIRECT(CONCATENATE(A1,"!$F$4"))

Pick a column and fill the series 500 501, ..., the formula e.g uses column A

 

[Sl33py]

Hi
I used =INDIRECT(CONCATENATE(5000,"!$F$4")) when I drag the formula down the sheet stays 5000 and does not go to 5001 which is the next sheet
Did I miss something? Can you please explain a bit more

 

[Drake2007]

You need 2 columns, the one to fill the rows for the worksheet names series (5000, 5001, ...) and the other holding the formula.
Excel won't fill the worksheet series when it's directly in the formula. You can then select both and drag to fill down, initially you do need to put 5000 and 5001 below it so that excel can figure out what series you need.