Hyperlink to find data form another Woorkbook and copypaste data back to activesheet

[UNIC0RN]

Hi All,
I have 1 Workbook Template (Worksheet Master) which have hyperlink to another workbooks based on value choosed from dropdown list and will link it to Worksheet Membership (each workbooks have worksheet called 'Membership') by using command button. My question is, by using VBA:

1. How can I automatically find the match value from Worksheet Master in cell E17 into Worksheet Membership in column J once its opened from hyperlink? Currently I just using Ctrl+F to find the match value.
2. Once match value found, can data in the column F,K & L (in same row where value found) automatically to be copy and paste it back to Workbook Template (Worksheet Master) in cell S17, S19 & S21? Currently I just manually copypaste.

This is the VBA code I wrote in Command Button 4 to link the Workbook selected:

Private Sub CommandButton4_Click()ActiveSheet.Unprotect "x"
ActiveWorkbook.FollowHyperlink Address:=Range("AE1").CurrentRegion.Find(What:=Range("S23").Value).Hyperlinks(1).Address
ActiveSheet.Protect "x"
End Sub

Thanks in advance. If someone willing to help and provide the VBA code, please tell me where to put the code.
*If anyone willing to answer, with respect, please explain it in simple word and simple English because I am not too good.