Formulas from one sheet to another

I have a lot of data on various sheets, all with different ID codes for a study. The data can also move sheet at any time depending on what point they are at in the study. I've made a formula that checks the data against various criteria to seperate them into three different categories. What I want to do is put the formulas on one sheet and have them also appear in the other sheets without having to re-enter the formulas in each sheet. I can't use VLOOKUP since the ID's change on each sheet and I've tried putting the formula in sheet1 and doing ='sheet1'!A1 for example, but it only takes across the value within A1 not the formula (I inputted data so that it was very systematically scored on sheet1 so it would be unlikely replicated in the other sheet had it taken over the formulas).

Please help!

I haven't put the formula's in, just where they are meant to be. On my actual spreadsheet there are about 9 other pages it would have to go to.

Hope this helps!