Change links in excel 2007

This is a simple trial project. If this works out there will be more projects to offer. I will provide an excel sheet, in which among other tabs there are three tabs called: Raw Mat – BOM (Bill of Material....Just in case you are beginning to doubt) Raw Mat – Cost Raw Mat – Cost Default Column D, I, L & M in Raw Mat – COST is linked to various cells in the whole worksheet. To eliminate the need for the tab Raw Mat – COST, I have included those columns in Raw Mat – BOM. The same columns appear at Column BA, BB, BC & BD. I want all the links to Column D, I, L & M in Raw Mat –COST to be linked to Column BA,BB,BC &BD in tab Raw Mat – BOM. After the work is done, a final check should be carried out to ensure this is correctly done. The check will involve saving your work first and then deleting the tab Raw Mat – Cost. By doing this it should not upset the workings in the file. I will provide the files, once I receive the bids and shortlisted the freelancers. Thanks