Hi,
see Ron de Bruin web he has the solution to your problem

http://www.rondebruin.nl/copy2.htm

if this helps please click yes, thanks

"cardan" wrote:

Hello,

I have an excel file with different worksheets that contain tables of
data that are imported from other sources on a month to month basis.
I would like to be able to have a macro that will populate a "master
sheet" (with no spaces) that will contain all the data from all these
worksheets. The problem is that each time the data is imported to
Excel, the amount of data grows and formulas would not be the best
answer since the amount of info on each worksheet keeps growing and
would have to be redone every time.

Any help would be greatly appreciated. Thank you for your time