Merging three different files using Power Query in Power BI

My task is to fully automate procurement dashboard. The procurement team gets 3 excel files which contains only one common column. All other columns are different. In 1st excel - Purchase Doc., and i...