Merging multiple CSVs and managing their dynamic Columns

I am new to Power Query. I am stuck in a situation . I will try to explain what i am trying and what i want to achieve.  I have a sharepoint repo, where I may have multiple CSVs present in multiple ...