Macro to pull data from another workbook

Hi,

I'm trying to figure out a macro which will help me to pull data from another workbook and past it in A10 (in attached WB). For example, in combo box if i select Master WB 1 then the macro should copy the information from sheet 1 in Master WB 1 and paste it in current WB (attached WB) in A10. Similarly if i select Master WB 2 from the combo box then the macro should copy the information from sheet 1 in Master WB 2 and paste it in current WB in A10 (not beneath as i don't want to see the data of Master WB 1 when i select Master WB 2 or other).

You are awesome. The macro is working perfectly as i needed. Thanks a ton

Hi, The above macro is working fine however i getting a popup message all the time when i run the macro. The message is "There is a large amount of information on the clipboard. Do you want to paste this information into another program later?" and it's asking for Yes or No. To get rid of this i have used Application.CutCopyMode = False but still i couldn't fix it. Is there a way to fix this?

Oh yeah.. got it where did i messed. Thanks for your help. Now it works fine.