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.