VBA code for matching and updating data across spreadsheets

[geomano]

Hi, I am struggling with one idea connected with a VBA macro for matching and updating data across 4 different spreadsheets.

The main concept is that I have one master file with specific values in column A. Those values correspond to tabs names in 3 remaining files.

I would like a VBA macro to:
1.Match the values from Master's column A to tabs names in 3 files.
2.Once the proper tab is selected, I would like the VBA code to copy specific cells from Master tab to the other one.

Seems a little bit challenging, but I will greatly appreciate some help.

[jolivanes]

Are these other files closed and in the same folder as the master?
Are there any other files in that same folder?
If there are more files in that folder, how do you know which file to look for?
Do the same specific cells have to be copied and pasted to all these sheets?