Loading Data Into Master Sheet Using Daily Reports

So, I'm trying to create a database, of sorts. I run several reports every morning that leave me with the information I need, but I would like to be able to store them in a master sheet, thus creating a database. That master sheet will be used by my co-workers and, at times, my customers or boss. Add in a few hundred new lines every day and it becomes a task in itself just to keep the spreadsheet up to date, manually. I'm only needing to do this now because the system I use now will be shut down starting next Monday. I (someone who has never had any formal excel training) have been tasked with creating a new way to track orders.

I can create a unique identifier tag for each line, but I don't know how to program or create a macro/equation to be able to filter and replace values in the tag's row, based solely on the tag. The combination of columns A&B in my test report will give me the unique tags. From there, I need columns E-L to be able to be updated from the new reports each morning.

If Sheet 2 contains a list of items that I have updated during the day and wish to place into the master sheet (Sheet1). I don't know the language needed to write the macro and any necessary equations.

My goal is to have my reports dump information into a master sheet, but only replacing/adding onto existing rows and columns that correspond with each other and creating new lines when no pair is found.

I've attached what my report should look like after I've filtered out the unneeded information. It will be this, every day, except with a few hundred more lines.

Imagine Sheet 1 is the master sheet and sheet 2 is the newly uploaded information.

TEST1.xlsx‎