Create Spreadsheet Code

My name is Dulce, I am looking for some help with a spreadsheet. We have data that is changing sometimes daily. My goal is to make the workbook semi-automated. I have multiple sheets and will be adding more in the future, where they all have different data in it but I need all sheets to speak to the main sheet in the same workbook. The detail in this is that some of the data sometimes does not match row and column-wise from sheet to sheet. I need all sheets to consolidate into one and have the data merge using one identifier that is the same in all the sheets because it's the ID Number for our database. I was able to do this by using a regular query and using the name as what the data match with and that worked for the moment but as we added more sheets and more data, that was not able to sustain the spreadsheet in order. I need help making the data match in one sheet using the ID Number instead of the name. I know that was a bit confusing and I hope that makes sense. Please let me know if this is something doable and how much it will cost, time and money wise to accomplish this.