Ok
I have searched the forum and I can't seem to find an answer that solves my problem, or at least one that I can implement.

I am trying to write a sumif formula that will do the following:

1. Use the range of all N columns in my entire workbook (under 50 tabs)(minus the sheet I am totaling on)
I also add new tabs regularly and would like the formula to continue applying to them without having to modify it every time I add a tab.

2. Use the criteria of an employee number (ex. 141).
On my total sheet the employee numbers are listed in column A. On every other tab the employee number is listed in column N (which is why I believe this should be my range).

3. Im trying sum all the numbers in column S, of all the individual tabs, into the "=" cell in my "totals" tab.

I have tried everything I can find online and continue to get errors. Is it possible to do this way or do I need to try a different function?

Any help much appreciated.
Thank you