I have attached the file i am working on.

Sheet 1 (Data) should display the data from all the other sheets as named in column A. I have done the first sheet manually but would like to create 50 blank sheets and get the information as i fill them in automaticly. Is this possible and if so how. I tried to drag each formula down but it leaves the sheet name the same and progresses the cell.

Also where i have merged cells the info just does not show up. Just returns (VALUE)

Thanks again for your time.

The Jackal