Oh yea, and I have way more than 7 different names with their respective row
ranges, so I don't think something using an IF function and a BETWEEN
function in sheet1!columnA would work well.....but I'll leave it to you
experts.

Thanks