I was asking for more information to help come up with a solution.
What you say you are doing should work.
As it isn't working I wanted to see exactly what was in one of the cells with a link.
When you say the data does not carry over from the original page, what does the cell show. Is there an error message, is it blank, do you just see the link formula???
Please copy the formula from the formula bar for one of these cells and paste it into your reply and then copy the cell itself and paste that into your reply as well.