Copying Multiple sheets data into a single excel sheet without copying duplicate headers
Hi,
Please see the document for your reference:
And, if you need to skip some header rows, you have to do it by using your own code, e.g you may skip those headers in the source range’s area of the sheet etc.
Thank you.