Help with changing link source

[MICHBROWNAOL]

I think this should be simple, but I need some assistance.

I'm writing a macro that copies a range from one worksheet to another, and the range includes links to other sheets. I'm doing a "paste special formulas" to copy the links over, but I then need to change the source from the the first workbook to the new workbook. so that the links pull the data properly from new workbook.

Any ideas?