Merge sheet data in workbooks to a single excel sheet

Guys,

I know that there is loads of posts on the web reagrding this topic, but none of the solutions out there seem to meet my needs and i'm not a vba expert, therefore, unable to tweek the code to get exactly what i need.

In a nutshell i'm trying to take 6 workbooks that each contain a months worth of working day data (monday to friday) and summarise this data on a monthly basis to a single sheet.

The file structure is identical on each sheet, and the bits that seem to be missing on most solutions out there is;

1) Only want to copy headers from first sheet or copy data to template sheet that already has headers defined.
2) Must copy formatting from existing sheets as some number combinations are a bit weird and treated as text.
3) Need to add column at end of summary sheet with workbook name as this determines who completed the task.
4) Also is it possible for the macro to check for duplicates against the base sheets to ensure that the macro isn't run twice.
5) Would be good if i could maintain the same summary sheet with separate sheets for each month as per attached.

I have attached 4 base files together with a summary file of the expected output, normally there would be 6 workbook files but unable to upload, so Bob and Sue missing.

Thanks.

Thanks for your reasponse, the crazy thing is i have found a number of macros that do about 50% of what i'm trying to achieve, but none that provide the complete package.

Maybe, i will have to get to grips with VBA in a bit more detail to enable me to cut and paste code from various macros to obtain the required result.

Ok so i'm about 80% of the way there have managed to create a workbook macro that loops through the required worksheets and merges data into a single summary sheet. However, i have created a worksheet templates for each operator and only want the data to merge if a date is entered in the first column A, whereas my current template copies all cells regardless.

Would also be good if the "Monthly Total" sheet could remain static as a template to enable me to have constant headers, and currently Operator is missing from the Header of column "H".

Any help would be appreciated.

(Big Thanks to Ron de Bruin as managed to very slightly adapt his macros to get this far.)

BUMP - any help or pointers would really help.

Thanks in anticipation...

BUMP - Any VBA Experts out there who could steer me in the right direction...