VBA Code to copy the 'names' in name manager to a new sheet with a different name

[rstuart]

Is there some simple VBA code that will allow me to:

copy the 'names' in the named cells referring to cells in worksheet one and offset those names with a text prefix (i.e. tab2'cellname') and apply these new names to identical ranges in worksheet two?

Any help appreciated.