Splitting data into multiple tabs

Hi

have a large sheet of data (500k rows) with week ending dates in column A. I need a macro that will split that data into a tab for each week ending date and rename the sheet with the relevant week ending date.

Have seen a few macros out there but can't seem to get them to work.

Can anyone help me?

small sample attached now

Edit: It was brought to my attention that this attachment may have contained sensitive information. It has been removed. Please make sure to scrub what you attach clean of confidential info and re-post it.