I need to establish lots of links to collect information for a summary.

I have numerous folders associated with different operations:
eg.
MM
RA
TS

Each folder contains worksheets with similar info for each week of the year

wk1.xls
wk2.xls
wk3.xls
..................
wk52.xls
etc.

I want to establish a summary that collects a total from the same cell in each sheet but forming the links has become a painstaking process, I'm sure there's a better way.

the link addresses will be ='\\server\folder\MM\[wk1.xls]!$C$16
='\\server\folder\MM\[wk2.xls]!$C$16
='\\server\folder\MM\[wk3.xls]!$C$16
etc

='\\server\folder\RA\[wk1.xls]!$C$16
='\\server\folder\RA\[wk2.xls]!$C$16
='\\server\folder\RA\[wk3.xls]!$C$16
etc
='\\server\folder\TS\[wk1.xls]!$C$16
='\\server\folder\TS\[wk2.xls]!$C$16
='\\server\folder\TS\[wk3.xls]!$C$16
etc

and so on.

except there's 15 areas of operation and 52 weeks in a year. I was hoping that simply dragging may work or a macro but cannot get there.

any ideas?

thanks