Numbers linking formulas to multiple cells
I have one formula for shipping that is on my master pricing sheet and I would like to link it to multiple cells on our product sheets so those individual products have the formula to calculate shipping for their individual rows. Then, as shipping rates change I only need to change the formula in the one cell on my master pricing sheet that will update shipping costs on hundreds of products. Right now I am linking back to the master pricing sheet's shipping formula by placing an "=" back to the master pricing sheet where the formula (as text) is located. This doesn't work. Many thanks for your assistance!
Mac mini, macOS 10.15