Macro to loop through multiple sheets

Hi Guys I have this code which create unique workbooks by filtering the column 12 in one sheet.
I was wondering if there is a way to change it so it filters column 12 in all sheets and then
create a work book with all the tabs that were in the source book and save the values respectively.

Please Login or Register  to view this content.