Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello! This is possible to do using indirect formulas. Basically creating a separate data table that contains the individual values from the multiple sheets and then using a final formula that uses the ISNUMBER function to filter out any reference errors.
It worked, thanks!