Need someone to edit Modify Macro's to work on entire work book

In the attached files, you will find a XLSM

If you run the macro contain with in file you will see that it Imports the other raw data files and completes a range of functions
Including: formatting, sorting, Clearing contents, renaming sheets and data headers....etc

The files will need to be in C:\Raw Data (directory) the macro i made currently runs across all worksheets.

Now with the help of another thread and the efforts on Both SinTek and Jindon and others who replied they created the folllowing macro's which summed and counted
between the hours on the dataset i provided . in that post
Here are the different macro's and approaches (BOTH worked very well)
SinTek

Please Login or Register  to view this content.

------------
JinDon

Please Login or Register  to view this content.

If at all possible can either be modified to to work across data ranges of worksheets and workbook

Attachments Xlsm and two .CSV files of raw Data ............ plus Zip file with complete dataset of CSV's