I would like to create a single excel spreadsheet that holds various links to other excel workbooks which each have data in powerpivot sitting behind them. i then hope to use vba code to go into each link, open the excel workbook and refresh the data in powerpivot.

I would like to create a single excel spreadsheet that holds various links to other excel workbooks which each have data in powerpivot sitting behind them. i then hope to use vba code to go into each link, open the excel workbook and refresh the data in powerpivot.