Linking multiple worksheets (same cell reference) to another worksheet

[sirperegrine]

Hi, (I hope I'm doing this correctly).

I have a spreadsheet with say 60 worksheets.

I want to link cell B19 from each worksheet to another worksheet (lets call it a summary worksheet) in worksheet order.

In other words, summary worksheet would have for example: cell A1 = 'sheet1'!b19, A2 = 'sheet2'!b19 and so on.

The problem is, each worksheet has a different name.

Is there a quick way of populating a column without having to type into each individual cell of the worksheet?

Any help would be greatfully recieved.

Regards,
Sir Peregrine

[FDibbins]

Dont know if you are still monitoring this post, but if the info you are referencing is in the same plave on each worksheet, in your summary sheet, type =sum( then go to the 1st sheet, click on the cell you want, hold down the shift key, click on the last sheet tabe that you want, and then press enter (add the closing ) if it asks for that