I have multiple sheets with 3 columns of data each. The first col is ID
info, the other two track hours and dollars, respectively. I want to add up
all the numbers in all the sheets in col B(hours) that match each particular
ID . . . and the IDs do NOT always come in the same rows. I want to do the
same for the col C(dollars).
My goal is a summary sheet that lists each and every ID with total hours and
total dollars for each.