Sheet Number

Input: Multiple Excel files with a single sheet of data. The sheet name keeps changing every time you get the data file. In such a scenario, you can use the sheet number instead of the sheet name to pull the data from the file.

Download sample input files here

Goal: Setup a DataFromExcel formula that pulls the data from the first sheet of a given file (immaterial of the sheet name) and puts it in one single place.

Hint: Use the number 1, instead of the sheet_name in the DataFromExcel.SK formula