I never knew this was possible, but i came across a dashboard where input is magically simplified because other tables when refreshed, "fetch" specific data wich was inserted on the main table.
It's not formulas or anything, lemme tell how it works so someone can explain me how to reproduce it...