Get data from multiple Excel file having multiple Worksheets

Thank you for your replies. 

The problem is a bit more complicated than in the example from the video because sheets contain Pivoted data with dates in column headers, and every file/sheet has different Dates (cloumn headers), therefore I cannot use the first row of any of the sheets as header. 

Still trying to figure out a solution with Functions and parameters...

:( :( :(

Hi,

I solved this problem by creating two parameters, one that holds file name and the other one that holds sheetname. Lots of effort on this one but it was worth because I learned some interesting stuff.

thanks again

Sab