I have found a macro which create as many workbooks as the different values in colum a sheet1
I need that all the sheets are processed and the resulting created files contain the same sheets but filtered for column a

Example
All the sheets have in colum a a code as
Aa
Aa
Aa
Bb
Bb
Cc
But the number of rows might vary
I need to create as many workbooks as the code (3 in the example)
The created file for aa will have all the sheets of the original file but just the rows containing aa
The row are already sorted
Column a not have to be copy in the dest files

Any idea?