Populating data from multiple sheets onto a summary sheet

Hi,
I'm trying to create a macro that will take data from multiple worksheets (the months) and populate it onto the Scorecard tab--the data needs to be appropriately populated in the corresponding dataset and month. When the user clicks "Populate" the macro will do the following:

1. Populate cells C4 to O4 in the "Scorecard" tab according to the names of the subsequent tabs in the order of the tabs. This is to allow the user freedom to track by month, quarter, year, etc. (the attachment currently has it by months though)
2. Populate Col B in the "Scorecard" tab based on the number of datasets/variables in the subsequent tabs.
3. Run through each of the tabs and populate the "total" score according to the appropriate time frame and data set.

Can anyone help me w/ this? Thank you so much in advance!