Calculating from IF statement

I have data pulling through from one main page (tab 1) in order to avoid having to retype the same entry everyday (into tabs 2-25).

I need to calculate new information (into a different cell on tab 2) off of the data pulled through, but when I try to reference the cell with the pulled through data it will not compute. Is there a way to tell Excel to look at the actual number in the cell and not the "pull through" formula it is using? I can attach the document if you need it to make more sense, but it is really confusing to look at.
Thanks,
Lisa