I have a folder location on a Shared Drive that currently contains two excel files (See screenshot). A new file gets added to this location each month in the same format.
These two files have the same Sheet named "Message Data". This is the only sheet I am concerned with in these files.
What I want to do is create a workflow that will read in all excel files in this location, pull only the "Message Data" tab and combine that tab for all files into one view via a browse? I have tried playing around with the directory and dynamic input tools but I don't think I am doing it write.
Do any of you pro's have any suggestions or advice? Thank you in advance!
