I always prefer this method, for each spreadsheet I will create required global variable depending upon needed columns.
Imagine if I have 3 spreadsheets and in each 3 col was there mean(9 col so 9 variable), I will do one procedure , by using that procedure I will call values from each spreadsheet and will proceed