1 sheet same data different cells (anyway to copy paste to avoid manual labor)

I am not sure how to explain this without showing a sheet. which i can mock up or wait til i get to work and upload....

So i have work book with two sheets... sheet 1 has a section for 22 people... each person has a different section... this is the pretty sheet

Sheet 2 has all my raw data that will. this data is just in a 1-22 for 4 sets of data...

so it would look like this

(Quality manager) (quality national)
Joe 95 86
AMy 70 100
cami 100 95

I would like sheet to to be able to just punch in these numbers and then they go to their respective spots on sheet 1. This i can do.. but here is what the real question is... can i set up Rep #1 so all his raw data goes to sheet 1 from sheet 2 and then paste in such a way that the other 21 peoples data will fall into place without having to manually do each one? So on sheet 1 set up first rep so it looks the way i want and then the data goes down respectively... I can't drag because its not consective... like joe 1st quality manager is in c27 second quality manager is in e 29 quality national is in h 27 and second is in j 27..

im sorry i know that is confusing... lol... any help would be super duper awesome.

Hello fruitypebbs,

Welcome to the Forum!

I am sure it can be done. We''l just have to wait until you can post the workbook. Once you post it, it should be a quick process to provide you with a working solution.

Hello fruitypebbs,

I don't see any manager names on the "pretty sheet" ("Overall").

A few other questions:

1. What are the "c" columns on the"Completion" sheet for?
2. Where does this info go?
3. Why don't the columns in "Month 1" and "Month 2" match?