Totaling cells from p.c. worksheets to a cell on a server workshee

[Guest]

I have six workbooks with 12 sheets each and multiple colums whcih I have
totaled with formulas. I need to link those colum totals to a central
worksheet on the server. I am having trouble linking colum totals from six
different workbooks to a single cell total on the server. I would like to use
links because I want to automate this process as much as possible.

 

[Dave Peterson]

I think I'd put the totals for each of those 72 worksheets in row 1 of each
worksheet. Then they'll be easy to find.

Then I'd dedicate a worksheet with formulas to retrieve all the totals that I
wanted.

Then total those cells and use it where I wanted.