Get Data From Sheet - Power Query

[cheeseontoast101]

Hi

There is no option for me to get data from sheet in Excel but I know this option exists for power query.

The only options I get are get data from - text/csv, web, table/range and then there is also the get data tab that has more options but none of them are that.

I'm trying to merge my data on that's all on different sheets into a pivot table.

[#2]

@cheeseontoast101 For me, the "From Sheet" connector existed only a short time. As I understand it was the new name for the "From Table/range" icon, which after a few updates came back. So, just use "From Table/range". It allows you that connect to tables, named ranges and dynamic arrays.