I'm new to excel, I don't know what 'compare and merge' does and how it would be applicable to my question
I need to keep all the sheets together , the work book is saved under a clients name so all staff can find all the relavant details on that client in one place.