Hi
I have a spread sheet which has all our managers on it (sheet is called Monthly Stats) with the branch they cover and their monthly statistics of that branch (upto 10 lines per manager), and I want to be able to update the main sheet but have all the information copy onto each persons individual sheet (including deleting and adding rows, sheets are named by person). e.g. all lines from the main sheet for Joe Bloggs copies all his information into his own workbook

I tried VLookup and some sub formula I found but couldn't get them to work, im new to this so not sure what else you would need to know, ive spent a good few hours trying to solve this so your help would be very, very, very much appreciated