auto populate (drag?) long list of links to other worksheets

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

thanks for your response, though I am having problems with it. Also, having to open all the books to collect values is not good.

To add to my initial post, I don't need the links to be live updatable. This whole process is to set up links once which will then update on each opening of the summary workbook.

I already have a much smaller version of this working fine, including updating links from closed sheets. But when I set that one up I copied, pasted and altered many cells. This one is much bigger.