I want to create a macro that allows me to seperate data from a spreadsheet that is in a pre-exsisting format.

I want to take column A which identifies the subject name with a numerical value or "API Number" and seperate those rows related to a specific "API" onto a seperate page for each API. I just cant make this thing work.

Does anyone have the expereince to help me?