I have several workbooks that link to one "Total" workbook. What I would like them to do is once the data is inputed, saved and the workbook is closed. It would be collected in the to "Total" workbook that is closed. Once opened it would collect all the data. When I run this file with the Totals...