Quote Originally Posted by Ariff_Chowdhury View Post
Dear AlphaFrog,

Thank you for this..

I run the macro and ran into the following problem;

The macro start pasting the data from row number 2 along with headers. In my source file row 1 has headers,and in the master workbook i have already define the same headers according to the source file.

I tried to change it but can't get where do i make change in it..... Can you please look into this

And a question for my understanding how many worksheets I can maximum add into the array,[For Each ws In .Sheets(Array("Arrangment", "Request", "Status"))] as there are more worksheets' data need to be copied in the master workbook.may be around 60 worksheets from 60 workbook.


Thanks again for your code and cooperation!
Change this...
With ws.UsedRange
To this...
With Intersect(ws.UsedRange, ws.UsedRange.Offset(1))

An array can have thousands of elements. It may be easier to just loop through all the worksheets in the source workbook using
For Each ws In .Worksheets
Then if there's a worksheet you don't want, it could be excluded with an If statement.