Copy paste autofilter data macro to new sheet

Hello,
Dear all,
I have a worksheet "data reqd" which will be generated by a macro based on the input of another sheet. I am herewith attaching my sample data.
Pls look at http://wikisend.com/download/155336/SAMPLE INFO.xlsm


I need an "AUTOMATIC AUTOFILTER AND COPY PASTE macro" which can do the following task on running the macro once.

1. Column H has the header Account Category.
I need to generate individual reports (like EO, CAA, ET, KQ etc) with range B7:W7 based on the cell value after filtering on column H (in a single sheet or in different sheets...not an issue). pls suggest me if I can repeat this for further autofiltering on another column values of the already filtered data.
hope you understood my problem.


thanks in advance
c.suryam