Macro for extracting data

Hi guys,

I am looking for an excel macro which when I click "Run" will extract the contents of columns C through I from two worksheets "Global 1" and "Global 2" into the respective worksheets AA, FA, KS and TG based on the Marketer values in columns E. Can it also be done such that when an additional Marketer is introduced into column E on any of the Global worksheets, a new worksheet is created with the initials of the newly added marketer?

Column B in each of the worksheets where the data is extracted to should generate a counter value of 1 when there is data in column D.

Once the extraction is complete, extracted data in each of the sheets is then sorted by "Ack date with the most recent data on the bottom.

I am manually creating this currently but I know it will be a pain as the data volume increases. See sample attached.

Thanks for your help.