Create and Summary Sheet

[Juliansmity]

Hi,

I would like to create an summary sheet that goes through all the sheets and pulls the relevant data from those sheets and displays in on the summary sheet.

All the data stays in the same row / cell on each sheet so I thought I could use a lookup but I cant work out how to go search for new sheets and then add that data to the next unpopulate column ?

Any help for be appreciated.

Essentailly I want it so that when I open the workbook it goes and gets the data from all active sheets and repopulates the Index file.

I've attached an example copy of the data file


Thanks