I have a worksheet compiled with data which is different everyday, this is a
basic worksheet with 8 coloums.

I basically want data from this worksheet extracted to 8 seperate worksheets
gouped by the heading of one of the columns.

What is the best way to get around this?