HI Guys

I want to know how to import an excel sheet from a Workbook "B" to the excel workbook "A" (where I have made the pivots graphs of certain source data).

All I want is to create a button which when I click it, a traditional browser-like window should open allowing me to select the input workbook("B") anywhere from my computer and after selecting, it should update (Replace or insert ) the source data of pivot in workbook "A", which would eventually update my graphs after a refresh button press.

If there are different methods of Replace or insert a data then please advise both separately.

I am not good at VB language, therefore I would prefer if you please put down the sequence of excel functions to understand the concept. I know how to create buttons but I don't know to make a function behind the button to open a browser-like window and replacing or inserting the pivot source data table.

Or if VB code is the only solution then please write me the code, I'll try to modify according to my needs.

Appreciate your help.

Thanks, Farrukh