MS xcel

Hi Godwin

One way to combine separate sheets, from different workbooks into one summary workbook is as follows:

Create the workbook that will combine all the separate sheets. Leave it open and open the first workbook that contains a sheet you'd like to move.

Right click on the tab of the sheet in question and choose move or copy. For safety's sake tick the box labelled copy then beside the option labelled "To Book" click the drop down arrow and choose the destination workbook that will contain all the sheets. Click OK.

A copy of the original sheet is now added to the workbook that will contain all months. Repeat with the other workbooks.

I hope this helps - let me know how you get on.

Kind regards,
Andrew