Hi,

the attached is an example of a vary large spread sheet. It contains a master list and sheets with account values as at the name of the specific sheet.

I wish to extract the account values from each of the spread sheets named as date into the master spread sheet. For example the value of account 100001 would be 100,065 as at 30-06-2014



Accounts.xlsx

Does anyone know if this is possible and how to do it?