Data Extraction Multiple Workbooks And Sheets To Master Spreadsheet

Hi All,

Refering to thread http://www.ozgrid.com/forum/showthread.php?t=135307, I have same problem and i tried to copy the same solution as provided in the mentioed thread. Either the code or the way i am following the solution is restricting me to copy the value in the desired workbook.

Can anyone have a look and make me correct please

thank you

Shido