This is perfect! Thank you p45cal, you made my day.
Say, not to be a nagger or anything, I have about 3000 rows with about 20 columns in each sheet and it takes about a minute thirty to run this code, any suggestion as to how to make a bit faster.
Again, awesome work.