Creating a master metric sheet
I have been hunting through the threads for a few days, and have not been able to find a clear resource explaining how to set up a metric sheet and then combine into a master metric sheet. I had created a "metric sheet" with my metrics as columns (approx 50 of them), it appears from what little I can find I should have created it as a 2 column sheet instead with my metrics down the first column. that is ok and will re create as needed but then how do I link the 20 or more sheets into a master sheet as new ones will be created/destroyed every few weeks. and the copy functions seem to be row based not column based anyway.
previous attempts have ended up with invalid references when I try copying the cells over.
Can someone point me to a learning centre article or some other reference.