I am ready
I started over but it still doesn't copy all columns - it misses the names and the columns after that.
Also it is better to copy all the cells - not only visible ones. And if it can copy only the data from these specific sheets - Crawler, Various, MandM, Fragrance, 5£. Because I have other sheets with not formatted and unnecessary data.
Thanks a lot for your help.