expand table column to different data table

[Ah_saaah01]

Hi experts, please help.

If I loaded lots of tables as shown below, how should I expand each Table as an individual data table? Without going thur each row and right click to add as a new query?  Or should I do when importing data? It always combines all files from a folder location. How to import all files, but keep each file as an individual data table? Thanks for your help in advance:) 

[Ah_saaah01]

Following the same question, in each table, assuming the project number is in Cell C7, Can I add a column to each table that the contains Cell C7 value in each row?