This is my formula I made which works for what i need it to do, but I can't drag it down and have it use the new row for my output.

=INDIRECT("'Evo Inventory'!E5")+INDIRECT("'Evo Order'!h5")-INDIRECT("'Evo Sold'!d5")

Can somebody help!?