Pulling cells through to different tabs and retaining their web links

Hello,

I have cells which link to various web address.

The cells themselves only contain names.

I want to be able to pull these cells through to different tabs but retain the function to click the name to take me to the web link.

Thanks,
Matt

I understand that you have a list of names with hyperlinks to web pages and you wish to transfer these names to other tabs in the same workbook and retain the link.
To do it manually, you copy the names and paste to the cells in the other Tabs. The hyperlinks then go with the names pulled.
You could also record a Macro to it.

If that is not OK, please upload a sheet with the names and also enter the desired result in the other Tabs.