Hi,

In the attached file, from A3 onward i have Formulas. From B3 onward, i have Sheet names. And from C3 onward, i have cell address into which formula is to be pasted. This cell address is EL37 and is same for all sheets.
As you can see in the attached file, cell B3=Sheet1 and C3=EL37, so code should copy formula from cell A3 and paste into cell EL37 of Sheet1. After pasting code should also drag formula from cell EL37 to Cell EL1442.
Next, As cell B4=Sheet2 and C3=EL37, so code should copy formula from cell A4 and paste into cell EL37 of Sheet2. After pasting code should also drag formula from cell EL37 to Cell EL1442. And so on,
Please see attached sample file for more clarification. (I am using Excel 2021)