Code to extend formula on changing ranges

Hi Experts,

I am pretty new to VBA, I am trying to automate a task where I have to remove duplicates from my table, sort the table, insert a formula and change formula to consider all the cells within the table. So far I was able to complete 2/4 steps and was able to create a formula I am trying my best however I am stuck at one point where I have to "extend" formula in one cell to take account of all the newly added rows because next time when I paste the new table in my macro it may have more/less rows and based upon that I have to change my formula which is kept in one cell.

I have also attached my working macro. I have added a separate tab called "Example" where I have outlined my steps. I am thinking the future process to be

1. Paste the data table in "Input" Sheet of macro
2. Run the macro and have result ready in cell F5 (Could be any cell) of "Input" sheet
3. I also need to copy and paste this result in a single cell of master table's corresponding row however I do not bother anyone about this step - I will manage it

If you paste the table (A3:C14) from "Example" sheet to A1 of "Input" sheet and run the macro1 you will see that I have removed duplicates+sorted the table based on column A. Can somebody suggest a code that would have updated formula in F5?

I have very basic knowledge of programming

Thanks for your time.
Best,
Bunty