How to Extract ALL Unique Values from one table's column to another table's column?

I am having serious issues trying to understand absolute reference within TABLES. I do not want to use the =UNIQUE function as it causes #SPILL errors and I need the unique values in another table. Furthermore, the =UNIQUE function is unique to Office 365 and I work in an office where most of our employees use Office 2019, so I really cannot use the =UNIQUE function even if that was the only method.

I have used the IFERROR/INDEX/MATCH/COUNTIF formula to extract all unique values from a column by referencing the cells themselves before, but I cannot reference it properly when extracting from one table into another table. Since I have to extract ALL unique values from one table's column to another table's column, I cannot understand how I should reference these columns or cells.

To the problem, I have two tables (named "ORDER_IN" and "INV") in two separate sheets ("ORDER" and "INVENTORY" respectively). The first table (Table "ORDER_IN" in sheet "ORDER") contains an order history of fruits along with their quantity and date. The columns are: "Fruit Name", "Order QTY", and "Date". The second table (Table "INV" in sheet "INVENTORY") contains "Fruit Name" and "Total IN". The same fruit can be ordered at multiple quantities in multiple dates. I need the workbook to serve two functions:

1. Sometimes, a new fruit can be ordered; hence, when I add it that "Fruit Name" to my "ORDER_IN", I want it to be automatically added to my "INV" Table. This is what I need help with.

2. Henceforth, I want that entry in the "INV" Table to automatically sum all values in the "Order QTY" column from "ORDER_IN" table and return the value to its respective "TOTAL IN" column on the "INV" table. I know how to do this using SUMIF.

I have added the images of the tables below. Basically, for example, I want the entry "Mango" to appear only once in the "INV" table with (20+80+80=) 180 under "TOTAL IN".

Table "ORDER_IN" in Sheet "ORDER"

Table "INV" in Sheet "INVENTORY"

Table "INV" in Sheet "INVENTORY" (Completed) [This is what I want, but automatically; below table was manually filled]

Finally managed to find the answer after hours of asking people around:

Type in this formula the Sheet "INVENTORY" on the first row under the Column "Fruit Name":

=IFERROR(INDEX(ORDER_IN[[Fruit Name]:[Fruit Name]], MATCH(0,IF(ISBLANK(ORDER_IN[[Fruit Name]:[Fruit Name]]),1,COUNTIF($A$1:A1, ORDER_IN[[Fruit Name]:[Fruit Name]])), 0)),"")

Then use: CTRL+SHIFT+ENTER

Then Drag the Formula to the rest of the cells and see magic happen every time you enter new unique entries in the "ORDER_IN" sheet.