Hi,

I was wondering if someone could help. I need write a macro that will open various workbook a copy and paste the value in a master workbook. The rick is that I will received the template on weekly basis and as such I need to combine the data on the master spreadsheet without loosing the presbious data. Each week is on a different sheet.

eg. Market Scandinavia.xls. (there is 8 workshet with all a different name)

sheets = week1, week2 and so on to week5

can someone help
many thanks