so heres a clean example.
i want it to pull the entire row into the totals page, but only if it has a value.clean example.xlsx

i have approx 7 sheets to work this across eventually