This might be a newbie question, but I can't find the answer. I have multiple excel file, all in the same directory. Files have the same name+weeknumber. So file01.xls, file02.xls, file03.xls etc. I want to copy/import one single cell (lets say A1) into a new workbook. So file total.xls, sheet1 row B should contain A1 of file01.xls, A1 of file02.xls etc. Surrely there must be an easy way to do this???