This is excellent tool for files in one folder. 

How can we do combining data from different worksheet in new worksheet within one file ?

Is it possible.?

I have attached the file. 

I want only coloured cells from worksheet - call , miss into follow up worksheet. 

combining data from differennt worksheet.xlsx

Hi team,

I am trying to combine two simple excel files just to learn this power query and getting this massage:

DataFormat.Error: External table is not in the expected format.
Details:
    cd5hk2xn.XLS

can you help please