Need: filter, paste info to new sheet, rename sheet, unfilter, hide column, filter next

need help.xlsm
Hi!
I need to Filter the column G, copy all the information in A-F and the information in G to a new sheet. Rename the new sheet with info from G1. Unfilter G, hide G, filter H, copy information from A-F and H into a new sheet, rename it with info from H1. etc, etc, for all columns up to BG.
Help?
Thanks!

For clarity, we are just looking at the Data tab, and will need to filter column g by "x". Also, when it pastes to a new tab, I only need to see the information in A-F and the one column that is filtered; all other columns should be hidden or deleted.
So far, I can apply a filter bar accross the top row, and I have it prompt me to select the first column that needs to be filtered. Then it filters that column and posts it to a new tab. I still need it to hide the other columns, name the sheet, go back to the main sheet, unfilter, hide column G, and loop so that it filters H and copies. You will be able to tell that I am very inexperienced in writing code and I appreciate any tips you may have.
Thank-you!

Please Login or Register  to view this content.

So after some thought I decided it was easier to just delete the non-static column in order to move on to the next instead of trying to unfilter and hide that column.
This way I could hard code more of it.
It might not be the prettiest code, but it does what I need.

Please Login or Register  to view this content.

That should do it...