I have a worksheet with one worksheet per client. However, I need to copy the client named rnages of data into one worksheet called DataSource. That is, ranges CLIENTONE, CLIENT TWO, CLIENTTHREE, etc. named ranges copied to the DataSource worksheet. Of course, the code would find the last blank row and copy the next range there, but how to I tell it to simply copy the entire range, not just the range name?