Testing the two workbooks you just posted, what I see is ...

The hyperlink button is not "copying" anything. All it is doing is taking
the user from the EXAMPLE workbook to the SENTENCE workbook.
That is what hyperlinks do ... take the user from one location to
another.

You should Google " VBA Copy Range Other Workbook "

What you are seeking is a macro to copy data between workbooks.