Hyperlink copy/paste issue

Hi Guys

I have a spreadsheet with a list of unmatched invoices. Durind the VB process, data gets split by column G (Buyers) and generates individual tabs as per Buyers id. The VB then pastes individual buyer's tab on to new workbook which gets emailed across to Buyers.
This all works fine. However, the issue is I have hyperlink in columns U & V. When the data as per individual buyers gets copy/paste to new workbook; these columns (U & V) appears as text on the email version of the excel file which gets sent across to the buyers.

Any assistance would be very much appreciated.

Many thanks in advance.

Any suggestions please.....