Create new sheets which split data according to Column (A) content

Hi everyone,

Yall are so much help its amazing !

Here is what i am trying to do.

I want to create new sheets according to the content in column A and also have my header copy to each newly created sheet.

To make it easier to explain I have inserted two excel spreasheet which show exactly what i am trying to do.

This would save me hours of work to sort through my finances.

Thanks Yall