Split Data based on 3 Columns into separate worksheets

Hello,

I need to split the data into worksheets (see attached) by the Advertiser column and then by the deal year and deal code columns. I need each worksheet to be named per advertiser and deal year_deal code. I took off and replaced the data since it is sensitive information.

Need help creating a macro or implicating one into the workbook to run for future reporting.

Thank you!