Combining excel workbooks with same header columns but various rows in a master wb

Hello I am trying to create a 'master' sheet that houses data from 4 workbooks. All four workbooks have the same headers but they are for different regions. I.E data for the east,west,north and south. Each workbook has a different amount of rows. I want to automate the process of combining the documents into one.

I tried power query but i'm not a expert.