I know there is a way to select arrays on different sheets one array at a
time. Is there is a way to select arrays (located in the exact same cell
range) on different sheets collectively? I'm trying to set up a template and
only need to doe this once but there will be in excess of 100 sheet tabs.

Thanks for your help.

DB