Copy sums to Summary page

I have a project that I am working on that is an hours summary. I have created one workbook and want to have the first worksheet be my summary page. There will be perhaps as many as 200 worksheets that follow containing a list of dates and hours worked with a sum at the bottom. The length of these columns will vary on all the worksheets. What I WANT to do is to copy the sums from each of the worksheets to a specific cell on my summary sheet. I know this may sound simple, but I simply have not found a way to do this. I have attached the workbook.

Here you go. I was thinking about putting error handling in but decided why bother. YOU WILL WANT TO MAKE SURE THAT THE ROWS IN COLUMN A ON THE SUMMARY SHEET MATCH THE SHEETS IN ORDER.

Option Explicit

Sub MasterCode()
Dim ws As Long

For ws = 2 To Worksheets.Count
    Sheets(ws).Range("B65536").End(xlUp).Copy
    Sheets("Summary").Range("C65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Next ws
Application.CutCopyMode = False
End Sub

If you are using excel 2007 you will need to add the developer tab.
File -> Excel Options -> Show Developer Tab...

Then in the developer tab click Visual Basic. When the window pops up right click on This Workbook -> Insert -> Module

Copy and Paste the code i gave you. Save. Exit Visual Basic. Go back to your sheet and go to developer tab. Click Macro. Run the macro.

Glad i can help and welcome to the darkside . Its amazing what you can accomplish with macros.

As I am continually updating and inputting more hours on projects and adding project worksheets as I run across them, I will need to make sure that my worksheets are in order as I have them listed on the Summary Page and then rerun the macro to update when I'm finished, correct?

Correct, as long as the summary sheet corresponds with the order of the other sheets you can add worksheets and the macro will continue to include the new sheets.