Hi All,

I am new to macro, I would like to copy D1 and B9 cells from all the work sheet from a particular location in the SharePoint to a master sheet(destination sheet) with out opening the Source sheets. . The source sheets are of different name, but in the same location and there will be approximately 25 to 30 sheets.

If you open the Master sheet. I want the D1 data from source sheet (1 October 2013.xlsx) in A2 and B9 data in B2 and then the source sheet (2 October 2013.xlsx) in A3 and B9 data in B3 and so on. I only want to open the master file and do not want to open the source files.