I have a workbook that has 52 spreadsheets for all the weeks of the year and
in each spreadsheet is 8 columns where the detective infomation is linked
from their workbook (8 detectives have their own workbook to enter their
stats). I now have a 9th detective, the question is will I have to link each
sheet (up to 52) in my main workbook to reflect each of his worksheets. Week
1 on his to week 1 on the main workbook, week 2 on his to week 2 on the main
workbook, etc. Is there an easy way to do this? I tried copying his column
from the 1st spreadsheet to all of the 52 sheets on the main, but then the
formula on each sheet is reflecting his 1st week. Is there an easy way to
get them to change to match sheet 1 on 1st week, sheet 2 on the 2nd week etc
without manually doing this?