Thanks John
I answered my own question just after I had posted. I was clearing the contents but had not removed the subtotals. Now the macro goes to the destination file first, removes all subtotals, clears contents then goes and gets the new data and it works perfectly. Can't believe I had spent soo many hours for something so simple.
Karen