Macro code to find and replace text in different worksheets based on master worksheet

Worksheet Name Find text Replacing Text
Sheet2 Table A Table 1
Sheet2 Table B Table 2
Sheet3 Table A Table 3
Sheet3 Table B Table 4
Sheet4 Table A Table 5
Sheet4 Table B Table 6

I have a master worksheet - Sheet1 with the above data

My requirement is I need to find the texts for e.g Table A, Table B in worksheet:Sheet2 and replace them with values Table 1 and Table 2 respectively.
Similarly I need find the texts for e.g Table A, Table B in worksheet:Sheet3 and replace them with values Table 3 and Table 4 and so on.

In real time, I may have 100+ worksheets similarly.

Basically I need to find 2 old values and replace them with 2 new values in every worksheet based on the data in the master worksheet .

Please help me out by sharing the Macro code as Iam a newbie to Excel Macros.

I have also attached the sample excel file .Please help me out here .