Morning!
Try this one out (if even possible)

Tracking performance areas monthly/quarterly by person

Sheet ONE (Entire MONTH)
PAGE ONE= Week 1 (Each week is printed weekly)
Each Row has different person
Each column has different category tracker (#'s, %'s etc...)

Page TWO (Sheet one)
Same info, week 2...

Last page is MONTH 1 end totals. This was the easy part.

DO same for 2nd and 3rd sheet (Quarter)

Now I need to take the data from each person's WEEKLY data (row) for EACH week and have these in a separate QUARTER sheet (which shows week 1, week 2 etc..)by PERSON. I am able to cut/paste, circular reference each person, but this takes a LONG time.

Is there a way to have excel recognize I need (selected data) from JIM's week 1 data to show in column 1 of his quarterly file? And then do this for each person WITHOUT cut/paste? JIM is row 4, 49, 91, 140...Column data needed: H4, B4, C4, D4 etc...

Thanks in Advance!