Hi Olly,

I would VLOOKUP from the the individual consultant spreadsheets (new collumn with consultant name in for that sheet) if the the client name was able to appear on the master spreadsheet, the VLOOKUP would pick up the consultant name right? EG clients moving from consultant to consultant, the name of the consultant would change accordingly. Would this work in your mind?

Sorry I left the monthly adjustments section in, I can sort that section (probably manually as these are rare).

The main requirement is getting Client name, expected commission and actual commission into the master sheet for each month.

EG. Tim, Duncan, Dave all complete their client spreadsheets for January, Master spreadsheet picks up all the client names for that month and product type, along with the inputted data from expected commission and actual commission recieved.

Appolgies for the long winded approach, I'm new to this! Your help is really appricated thank you!

Kind Regards,

Duncan