Yes this makes sense!

what you need to do is record a macro where you use
filters, this way you can create the individual sheets
with, the headers.

what you need to do:-

1) start recording macro

2) set data- filters- auto filter

3) select a value from column A for your filter

4) select all - copy

5) create new page - rename "same name as filter value"

6) paste all data into new page

7) select initial page - take data- filter- auto filter OFF

8) stop recording macro

now you will see how the macro is used you can ask
specific questions for any areas not understood, but we
can modify it from there!

Robert Couchman
)