Question: what is the excel formula to pull data from another sheet?
Answer: Start typing the formula =19%* in cell B2 on sheet VAT. Switch to sheet Sales, and click on cell B2 there. ...  Press Enter to complete the formula.