Macro to extract data from 4 different spreadsheets into a master report.

[sebastosh]

Im new to VBA and have no idea how to start this project, I have been teaching myself but i havent gotten very far with this project.

I’m trying to run a report summarizing 4 different workbooks, these workbooks contain information in different spreadsheets within them on the monthly results of different stores Ex Revenue, Variable Costs, Fixed Costs. The master Spreadsheet looks something like this
Bogota Miami Buenos Aires
Revenue Info I need from workbook “Bogota052014” Info I need from workbook “Miami052014” Info I need from workbook “BuenosAires052014”
Costs Info I need from workbook “Bogota052014” Info I need from workbook “Miami052014” Info I need from workbook “BuenosAires052014”

I would like to put a search button on a master spreadsheet where I can type the name of the file Ex. “NewYork052014”, ”HongKong052014”, “Miami052014” etc. and this will search for the file in the folder where all of the workbooks are and extract the data from them. The data I need is located in specific cells within the spreadsheets in the workbooks Ex. ‘’'Revenue'!O12”” , the workbooks are not standardized so the cells are different for each workbook. This data will go into an specific location on the Master spreadsheet Ex. “B3”.

Thank you very much for your help.

[sebastosh]

Does this even make sense? is it doable? Thanks

[sebastosh]

anyone has any clue?