Pasting data from other user defined workbook difficulties

Jeez, that works really really well. Thank you so much for the help.

Originally Posted by Mumps1

The macro assumes that there is data in column A of all the worksheets.

Question, (apologies if its already been answered, I cannot seem to find it for the change to usedrange) what if the only place that has constant data is "C". A & B may not have data but are still part of the row?