Make a copy of the main sheet. Select all the cells. Choose Edit | Copy and
turn right back around and choose Edit | Paste Special with the [Values]
option chosen. Links to cells on other sheets/in other workbooks will be
removed and you'll simply have the data/values left on this sheet. You'll
also still have your own linked sheet to work with in the future.

Now if I've misunderstood you and you need to remove the hyperlinks to some
sites that are in the cells, then some VB code is in order:

Put this code into a regular code module, again, make a copy of your primary
sheet. Select the copy and run the macro. Poof! Hyperlinks are gone from
that sheet.

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

"LinkChallenged" wrote:

I created a workbook which contains domain names and prices (going to sell
them). All the names are on the first tab are in alphabetical order and I
made tabs with the industry these domain names belong to. I copied and
pasted from the main sheet into the various tabs and linked the cells so if I
made any changes to the name or prices, it would do it accross the board.
Now I need to undo the links because people would like to be e-mailed domain
names within a certain category but I'm finding this can't be done. When I
try to copy and paste the cells from any of the tabs except the main,
different names then the ones I selected are getting pasted. I don't know if
this makes sense but I sure as hek need help in removing the links.