the #REF! error means your sheet names aren't correct...

In article ,
Carlee wrote:

THanks for the quick response. Using what you have provided, i am now
getting a 'Ref!' error.

Ideas for the desparate one?