how to automatically update data in multiple sheets

Hi all,

If you see the attached file, you will see a workbook with 46 sheets. The first one the "master file" is the one to add data and those data I want to be distributed in the other 45 sheets based on the agent name I have in the column A (the 45 sheets are named by the agent name). All sheets are similar.
Every day I will add more data in master file and all the sheets should be automatically updated...

I cannot use vlookup since the common column is the agent name and I have many rows by the same name.
Is it possible?

I saved the attachment as xlsx because it was too big..

If anyone can help me I will be grateful...