Hi rvasquez,

As guided I have changed the file path. and clicked the button at Jul2012P2_Sample(1).xlsm
and studied the action.

All the calculation is great effort and thanks a lot.

It works Great, But completely reverse. Im worried that my explanation is not good.

An auto generated file will not have this type of genius coding inside. May be we have to take this coding to AB.xlsm

---
Step 0 :
a : Assuming that we have a auto generated set of excel file named already like Jul2012P1.xls, Jul2012P2.xls, Jun2012P1.xls, Jun2012P2.xls, Feb2012P1.xls ... so on, upcoming month will auto generate from the timer machine to this folder - All files will have only data up to (A : P)
Coding cannot be inserted each time by the users. So... We have to Make AB.xlsm is the Main File with the coding.

b: AB.xlsm : will contain WorkSheet (WS) Start Page, Master, Jan_P1, Jan_P2, Feb_P1, Feb_P2,........., Jul_P1, Jul_P2......, Dec_P1, Dec_P2
AB.xlsm will also contain all the necessary coding to get the result from the relevant month (stated below Note1)

Inside the month WS:Jul_P1,
- Pre-filled data will be occupied from A2: Z23(Employee Name , Code, No of Days Present, Total R Hrs, Extra Hrs, Total Pay )
- Save Button - For saving the current period into new workbook with the same name has the work sheet name

Main file is AB.xlsm, from here the users clicks the button and then the action takes process

Step 1 :
1. We first open the Main file "AB.xlsm" > Start Page >
2. Selecting the period(Note1) It will give, from which file we have to get the data.

Note1:
User selects the file to pick the result WB: AB.xlsm > WS: Start Page > (A2) YEAR , (B2) Month (B2), and (C2) Part = (E2) eg: C:/......Jul2012P2.xls(m)

3. Then we should have a button on the Start Page which will Trigger the action > Open the exact file
4. Calculation takes place (which is happening now)

Step 2
1. Receive that calculated data and consolidate them into AB.xlsm > Relevant Month eg: WS(Jul2012_P2)> to A25 to Till required

Step 3
1. Finally the required result we be collected to top pre-fixed table(A2:Z23) with respect of each employee wise.
2. Clicking the Save Button will leads to save the particular sheet for future reference.

Sorry if I am again confusing, If you want i can explain more...

Thank you so much


note2: While calculating, some data are "######" how to avoid this. ?!