I need a macro that can search several workbooks with alerts disabled find a
number say (5-510) in a several cells in several worksheets in each workbook
replace it with a new number say (5-511). Save and close. Also I need to
know which workbooks it changed values in. The name is also in cell c2 on a
Data Entry worksheet.

Thanks for the help.

I've tried several things but couldn't get them to work.