Macro Formula GET.WORKBOOK ??

[ahmedhtahet]

Hi, I searched about how to make drop down list from sheets name
and i found couple answers by VBA and Formula GET.WORKBOOK and all works fine

but when the guy in video used GET.WORKBOOK he said it's a macro formula
and didn't work in cell only used in "Name Manager"
also you cant make a drop down list directly from it

so any one can tell me about macro formula and this one what criteria or argument can hold
(sorry i'm not good in English i may not described last phrase as it suppose to describe)

the video i've seen

 

[shg]

What is it you want to do?

 

[ahmedhtahet]

i want to know more about macro function
is there more than "GET.WORKBOOK"
and if there more what did they do?

 

[shg]

See https://support.microsoft.com/en-us/kb/128185