Sorry I'm brand new to this forum and don't know how to upload files.

I'm also unfamiliar with collections. Is there any easy way to assign a range (e.g. Data!A1:F10000) to a collection?

Thanks to all for the assistance.