Convert List - Hyperlink - Template - Auto Email

Hi Wise Ones...

A daily shipping list is provided ea morning (Daily.xls)
* Ref No. * From * To * Qty * Wght * Due Date

I'd like to set up macro to
1) Auto Hyperlink ea Ref No. column A (daily.xls) to Template (alert.xls)
2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls)
3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs.
i.e.. B1=
index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0))
4) Auto Setup to E-Mail Body (alert.xls)
5) Auto fill E-Mail Subject line with A1 value (alert.xls)

Task 3 can handle on my own but the others have proved difficult to figure
out on my own.
Any assistance appreciated

Brgds in advance, Steven