Sorry Paul,
You're right: I DID say "Apple" and "Fruit". Afterwards I reconsidered, as it seemed easier to go with a simpler naming convention.

I tried your new code, corrected one problem (my problem) in naming my worksheet (should be like this): 
Set DstWkb = Workbooks ("Required Reports by Region and Date.xls")
then before I ran it again I noticed that it was just copying and pasting into the same worksheet, not selecting any other one. Did you leave part of your code out?

Thanks for your help.