Macro to copy and paste changing number of rows

Hello,

I'm looking for help for a macro that will copy and paste a range of data onto a new sheet. I've attached the workbook, with some sample data. Basically what I need is for each header, ie "Mega AHT", copy the data below it (A3 - F7) then paste it onto a new sheet. Then come back and grab "Inet AHT" (A9 - F14), copy and paste it onto a new sheet.

This is a daily report, so the range of the data changes daily. Any help would be greatly appreciated.