Automatically copy specific data from one spreadsheet to a different specific worksheet

I'm new to VBA/Macro. Have a master sheet called Check Register. Need specific data strings to copy from "check register' to specific worksheets. I can accomplish this with advanced filters, but I want the tasks to be performed automatically as the source data is entered.

upload the sample sheet

Sorry about that. Here is a sample file. Thank you for you time.

Hi,

Please try this code :

Please Login or Register  to view this content.

If you're satisfied by any members response to the issue, Plz Add Reputation by using the star icon at the lower left of their post.
If solved please mark the thread as Solved

this will clear and copy data every time

Thank you for your responses. To answer one of the replies: I will have 11 of the IN accounts (sheets), 11 of the OE accounts (sheets), and 20 of CE accounts (sheets). I might need to delete or add sheets in the future.

If Sheet name (starting three digit) match with the code then copy otherwise skip and you can add / delete sheets.