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