Maybe like shown in the attached.

Attached Files

3D_Lookup.xlsx (17.4 KB, 9 views)

Thank you for doing this!
Hmm this seems to be only picking up the latest record in the first sheet? When I then add another one for company A in the other later sheets it doesn't update it. I want it to be able to pick up the most recent record for that company name within the whole workbook essentially.

You are right.
Forget about that workbook.

Ahh. Do you think what I want is impossible?

I wish I could get the information to update live into 1 table. The real spreadsheets have userforms to add records, so a new line is made per record. Would be great for that line to auto update to a table on a separate workbook (without VBA So the user doesn't need to have the other workbook open), and as each user adds a record it adds to the same table in order... But I can't see how that is possible

I don't know if it is possible.l

If you can accept helper cells like in sheets 1:4, H3:I28 and sheet Dashboard H2:H5 then you might want to take a look at the attached workbook. Helper cells can be hided or moved to somewhere out of sight if you want.

Attached Files

3D_Lookup_3.xlsx (20.6 KB, 6 views)

This works great thank you!!

In the document I will actually be using - each sheet will have about 8 columns and for the latest record of each company I would like to bring back all columns associated with the company.

I added an extra column on sheet 1,2,3,4 but when I try to bring the most recent one back onto the dashboard it just comes back with '0' (obviously I am doing it wrong!!).

Do you know how I could add extra columns and bring them all back as well as the date?

Again thank you soo much for this I have been so stuck.