Is there a way I can have a macro look at a worksheet and look down a certain
column, if the number in that column is x then return the value of a certain
column.
For example:

Summary worksheet macro look at jan 08 worksheet. Then go down column "C"
and if they is a 0,1,2,3,4 then grab the amount in column "G" and continue to
add the amounts together when at the end of the worksheet place the total in
the summary worksheet Column "C" cell 5.