Excel 2007 :: VBA - Place Formula X On Sheet Y In Cell Z?

Excel 2007 I have 80 very similar sheets. The only difference is the sheet name (Phase A (1), Phase A (2) etc.). I want the formula located in cell B5 to be different on every sheet.

I have listed the desired formulas on a single seperate worksheet, named "Overview". On this sheet, the following columns have these data in them:
A - Sheetname (example: Phase A (1), Phase A (2) etc.)
B - Cell location (example B5, constant)

C - A formula (example: =Sheet1!G47, =Sheet1!G48, etc.)

I would like to create a macro that will loop through all the sheets, doing the following:
1. Check if the sheetname exists in column A of the Overview sheet
2. If it does, take the formula from column C of the Overview sheet
3. And put it in the cell specified in column B of the Overview sheet

Here is some code, to illustrate the above. I know the code is mostly nonsensical.

Code:
Sub Enter_formulas()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets

[Code]....