Hi All,

I've been working on a project recently to create a variety of client spreadsheets for around 10-13 consultants.

I've created these spreadsheets and I'm pretty happy with how they look.

I now want to be able to link all these spreadsheets to one Master workbook, which is accessible by myself and a few other senior managers. Accessibility is fine, I can sort that. Infomation taken from our consultants sheets would be client names and commission tracked.

My question is, how would I go about creating a link from all of our consultant’s sheets to our master sheet to provide live/hourly updates on data? I've never used a Macro before, but I am keen to learn if this would be possible to create a solution!

Any advice is appreciated!

Kind Regards,

Duncan