I need to SUM weekly spreadsheets onto a monthly spreadsheet summary sheet according to personal name. Rather then clicking each individual cell to add I would like to know an easier way as the reference position can change on each weekly sheet and clicking pages of cells is very tedious. I have three columns of data beside a column of names on each seperate weekly sheet. What is the best way to add the data for each name onto a new monthly sheet? Please help.