I have 12 workbooks,every workbook has 12 sheets,and every sheet has different type of road vehicle survey data in same formate and these data has time interval ,for ex the data is,

Time car T.W auto minibus bus 3WGoods LCV HCV MAV cyc CR other
7-7.15 58 30 15 2 6 2 1 2 0 0 2 0
7.15-7.30
7.30-7.45
7.45-8.00 like upto 24 hours.

car,T.W,Auto,Minibus,Bus comes under - Passenger Vehicles
3WGoods,LCV,HCV, MAV comes under - Goods Vehicles
Cycle,Cycle Rickshaw,Others comes under - Slow Moving Vehicles

Then i need Total Passenger Vehicles,Total Goods Vehicle,Total Slow Moving Vehicles ,Total Vehicles ,Total PCU Vehicles for every one hour(like 7-8,8-9...6-7)using Visual Basic Application .How to i calculate every sheet?Because i am new for VBA .
I really hope that you guys can help me with some code and/or point me into the right direction.
Thanks in advance guys!