Take data in one sheet and merge it into a form on another sheet???

I am trying to take the data on the sheet called "monthly totals" and have it merge onto the sheet called "report" for each of the employees I have data for. Is there a way I can do that or am I out of luck?

All I basically need to do is get whatever is entered into the "monthly totals" sheet to be placed in the correct cell on the "report" sheet for each employee. I think of it as like a mail merge in word but maybe I am taking the wrong approach.

Any help would be appreciated as I'm not very good with the programming part of the office products! : )