Pulling data from multiple spreadsheets without opening

Hello,

I would like to pull together data from multiple workbooks into a consolidated workbook without opening the individual files. I would like to pull specific worksheets from each of those workbooks into my consolidated workbook. Ideally, it would look exactly same, but it has to reflect changes in the underlying workbooks (so there has to be some link between them, or a refresh button that pulls the data when clicked).

The workbooks will be located in one directory.

Is it possible to do something like this using VBA.

Thanks

UPDATE:

I've attached the excel files below as an example of what I'm trying to do. I'm still a beginner at VBA, so the two links provided below were difficult for me to understand. The consolidation workbook is what I'd like it to look like. I'd like to consolidate the workbooks into different sheets. There may be cases where the individual workbooks have multiple sheets as well.

Workbook A.xlsx
Workbook B.xlsx
Workbook C.xlsx
Consolidation (How I want it to look).xlsx

Perhaps try this addin The code is also available

Originally Posted by anthony_91

I don't want to try and addin as this will have to run on other people's computers.

Why not install it on other people's computer then? After all it's only VBA with an interface?

There is also code for merging at http://www.rondebruin.nl/win/section3.htm

I'm not sure what your end result needs to be, if it's just a copy of every sheet into the main file that could be easier.