Morning all,

Is there an easy way to calculate the sum total of cells across every spreadsheet in a directory. EX. Cell A100 is a calculated total for the column. There is upward of 1,000 sheets in a particular directory. I'm looking for an easy way to have the total of every workbooks Cell A100 added together.