Macro for Multiple input files with different Sheets name

[kauser]

Hello,

i am working in a workflow and there are multiple inputs files (around 15) and each of these file have single and/or multiple different sheets with different data. How can i create a macro that will help to bring all these file along with sheets name then i can mapped data from these sheets into different places on my workflow(as requirement). i am not combining or piling data from all these different sheets into one. i have found multiple articles and examples but all of these are compiling/piling data from all different sheets into one. For example here i illustrate list of my all input files along with different sheets name 

File Name                                                                                                                                          sheet name

ASIA	INDIA
	CHINA
EUROPE	UK
	NI
AMERICA	USA
	CA
AFRICA	EG

My expectation is how can i get all these sheets name and then also how can i map data from each one of these sheet into my workflow. 

INDIA

CHINA

UK

NI

USA

CA

EG

I also tried with Dynamic input tool without Macro then i got error message "check your path" and/or " file is corrupted" 

[Qiu · Accepted solution]

@kauser 
Check this answer.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from...

[kauser]

@Qiu  this are not answering my question because i am trying to bring different sheets from different input files.