I think we're almost there....

Instead of the data pasting at the bottom of the Sales Log in the Master File, what can be done to paste it in the corresponding location to the Sales Person File i.e. Sales Person 1 .Range("B3:E1002").Paste. Otherwise the current code will create duplicates.