Populate Master Sheet with data from other sheets in workbook...

I'm sure this is easy, but I can't see how to do it the way that I want it. I have attached a mock spreadsheet. It only has four columns.... I have multiple tabs (sheets) with the same data headers... I want the data I enter in the worksheets (LOCATION1, LOCATION2, LOCATION3) to populate a master sheet in the same workbook (MASTER ACCOUNTS), in the order that the tabs are in the workbook.

The "HOW FORMATTED MSTR SHOULD LOOK" tab is the what I'm going for if the autopopulate worked the way I envision it.

This can't be as hard as I've made it. Any help would be greatly appreciated.

First of all SixthSense... I appreciate you even taking the time to look at my issue. I apologize in advance for not knowing Excel better, but I have no idea what to do with the code you sent me. can you give me a more thorough set of instructions?

Again I'm sorry... just obviously not as versed in Excel as you are...lol. Thanks again for your time.

Marty

I appreciate your patience SixthSense...

I did what you told me to the mock spreadsheet and it worked slick as a whistle. I tried doing it with my actual spreadsheet and it keeps giving me the error messages attached. I've attached the actual database so you can see what the tabs look like etc. I think we're almost there... if this works I will most certainly owe you a drink of your choice

Thanks again for your help.

SixthSense.... you are the BOMB! I can't tell you how much easier you just made life for me. Thanks so much for helping me with this. This truly is a great site for the smarter folks (you) to help out us simpletons...lol.

Again, thanks so much for taking the time to help me with this project.

Marty