Automation and creating report

[Onemajor]

Hi, Currently I am working on a project where I get excel or csv file from vendors, need to clean that file and then create dashboard. I have more than 25 vendors for different states( for example: CA, LV, NY and other states). Some of the states have 2 vendors some have three. Each of these vendors will send data in different format and different names. I get this data in weekly. 

Now my question is how can I make it work so that for each states I can combine data and create one excel file that will be easy to visualize? Please suggest.  Thank You.

[alexnajm]

You'll have to read in all of the data and figure out how to align data between all of the vendors - for example if one file has a [Sales] field but another has an [Amount] field, they have to align in the same column. That way, you can bring them all together into one file and use it for your dashboarding