Reference workbook from hyperlink in cell

I am trying to insert a hyperlink into a cell and refer to that hyperlink and extract data from it.

How do I do it?

Thanks.