Hi Andrew and many thanks for your response, if I send you the workbook it might be easier to explain. Is that possible
Hi Andrew, can I send you the sheet.
There is a Tab called Summary and I have included in the headings of this Tab the cell references I wish to return the information from. The common identifier is in Column A, this matches the cell G4 in each sheet.
I did try a lookup table but couldnlt get it to work
Hi Andrew, yes that is correct. The reference in Column A is from a Tab and identifies the sheet.
From each sheet I then wish to return the information contained in the cell referenced in the column
Nope, it is the data in Column A which refers to a specific sheet
Okay, I will give it a go, but will the Summary sheet include all the information tabled, G4 reference in Column A, B14 in Column C etc
Thanks Andrew, tried it and it works fine.
Just a quick question, if I add any additional Tabs into the workbook in exactly the same format will they also carry into the summary sheet?