Power Query only showing one workbook when pulling from a folder|Power Query|Excel Forum|My Online Training Hub

Hello,

I have a worksheet with original data that i have created multiple power queries from for each team member to action and add their comments.

I'm then trying to do a power query back from these tables into a master spreadsheet. I can get one workbook to come through however the others appear as an error. saying An error occurred in the 'Transform File from New Test files' query. Expression.Error: The key didn't match any rows in the table. Details: Key = Record 

Table= Table.

As the headings are already created from a query and I have checked they are identical why won't this work?

Is there a better way where we have a data base, then assign to multiple of people to action and load their updates back to a master file?

Any help will be greatly appreciated as currently it is a very manual process.