Copy Range names to applicable sheet

[howard]

I have range names for various range on sheet1 for eg BR1, BR2 etc that will be the same as the sheet name


I need code that will copy the data from the applicable range name to the appropriate sheet using paste Special (using Paste link if possible)


The comments , cells values and fill color must update as soon as the items in sheet1 is changed



Your assistance in this regard is most appreciated