Hi everybody!

I am quiete new at VBA. I am tring to make a code for refresh link in a mater sheet if I copy a definied sheet.

I have 20 sheets called V001, V002, V003 etc... I also have a sheet called MasterV. Every subsheets V001, V002.. to the master sheet.
For example MasterV B6 cell='V001'!A6+ 'V002'!A6+.... So what I need if I make a new sheet called V021 which is hadnt been exsist before refresh the link in MasterV for this = 'V001'!A6+ 'V002'!A6+....+'V021'!A6

Is there any possibility for this? Or is it too complicated for VBA?
Thank you so much!