Auto Sorting Multiple Columns - Last Row Will Not Sort

Good Afternoon.

I would like to call on the powers that are Excel Help Forum.
I am currently working on a database that catalogs companies by :Company Number, Number of Employees, Address, GPS Coordinates, City/State, and Date established.

I am attempting to make the rows Auto Sort as they are being input into the sheet, (Smallest to Largest) by company number and number of employees.
I would like to input the entire row before it sorts. I have attached a small sample with the code I have so far, but the last row input will not sort properly. The last row entered sorts only by Company Number an not by Number of Employees. I know that using merged cells is frowned upon, however, this is an established database and people entering the data don't like change. Any help would be GREATLY appreciated. Thanks in advance.