Create and populate sheets based on values in master list

I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for.

My workbook will have a master spreadsheet that is periodically downloaded from an online data base. The master sheet has contents in Columns A-BB and is approximately 1000 rows long depending on the changes to the data base. Column AC has a value for who is next to go on the ticket. There are 10 entities that could be next to go for example "CTLOR", "COMOR", "FTMETR", etc... And column AO has the dates that they became next to go on the ticket.

I would like to have VBA code that creates a new sheet in the work book for each unique value in column AC (10 sheets) and names the sheet based on who is next to go. Then, IF the party has been next to go for more than 30 days, copy that row into the corresponding sheet that was created.

So after running, there will be 11 sheets total including the master and each sheet will contain rows of data from the master that belong to the corresponding member and have been outstanding for over 30 days.

Im new to VBA but hoping to get pointed in right direction here. I was able to achieve something close using formulas, but i would like to have more customization with VBA. Ideally, I will be able to break down the tickets even further by ticket type within each sheet which is stored in Column E.

Thanks