I have a summary spreadsheet (containing 30 tabs, representing individual departments ) "linked" to 12 individual monthly spreadsheets, with similar tab names as summary spreadsheet, all "linked" together using Xlookup and Index Match formula.
I there a way (other than copying some 31000...