Big formulas no longer letting me add - getting 'SYNTAX OF NAME NOT CORRECT'

I have two spreadsheets, spreadsheet one has many tabs and the data on it and spreadsheet two is the 'Dashboard' spreadsheet that is pulling the data from spreadsheet 1. I've built out the formulas (...