I have problem with combining five workbooks (one sheet in each workbook) into one master spreadsheet and update the master spreadsheet each time the workbooks are updated. Do you have an idea or a code in VBA to approach the problem? I am using excel 2010