How to Automate data extract frm M'sheet into separate worksheets.

Hello,

Every mth I generate a Billing Report using a third party provider and export the raw data into a excel spreadsheet to filter/sort and copy/paste, according to criteria "Accounts" into separate worksheets reflecting. Its a very tedious process which is flawed by the manual copy/paste function.

What I'd like to do is when I export the raw data into the Mastersheet worksheet, excel filters the range and exports the data into its respective worksheets according to the criteria being Account number? But I also want the spreadsheet to be dynamic in that when I paste NEW raw data into the Mastersheet, excel will change to reflect it?

Im sure this is possible -unfortunately I do not have the vast experience and knowledge to do this. I have looked at YOUTUBE [where would we be without youtube] but majority of tutorials either just miss out what Im wanting or its too complicated for my little brain to understand!?

Could someone assist?