Drop Down List hyperlink to sheets in another workbook

Dear Boongan

I already found out how to do that by using formula: =HYPERLINK("[Stock Plan]"&$A$1&"!$A$1","CLICK HERE"). So, if i type the sheet name in A1, it will directly go to that sheet. Anyway, thank you very much for your ideas.