I need a excel VBA expert

I have multiple workbooks that I have set up providing short term stock price history through Reuters. I would like to make a code that consolidates the data from these multiple workbooks into one. This means that each individual workbook would have to load to render up to date information through Reuters, then consolidate all the updated data into one workbook.