Merging multiple sheets onto one master sheet

hi guys,

many thanks for the prompt assistance - jraj106 I could not upload a sample due to customer confidentiality.
Thanks Trebor76 I tried your macro and it looks like it has worked - 63,000 rows which is roughly what I would expect. Will validate it but all looks good, and also ran very quickly which was a nice surprise.

Thanks also to kvsrinivasamurthy for your assistance.

Dave

Data validated, spot-on - worked well with powerpivot to provide a perfect customer solution. Thanks again.