Separate Rows Based on Content & Place in Different Worksheets

[Small Paul]

Hi

I have a worksheet [report] which has defining content in column A, e.g.

A1 - 5
A2 - 5
A3 - 7
A4 - 8
A5 - 8 etc

I need to have a new worksheet opened for each (5,7,8) and the content placed in row 10 of the tab.

Please, can anyone help?

Regards
Small Paul.

 

[Small Paul]

Yes, the headers are in A1:H1
The data is in A2:H*

 

[Small Paul]

Hi Fluff
Apologies, I have sorted the issue. My colleague was using the wrong drive.

Cheers
Small Paul.