How do I set a table's range to automatically adjust to source data?

[holt3130]

I cant figure out how or if it is even possible to have a table automatically adjust its range or the number or rows it has based on another table

I have two tables:

Table1 is raw data that is added two daily

Table2 has formulas with column header references to Table1 that processes the information and converts it to a readable format. (basically barcodes to words)

Is there a way to get Table2 to automatically resize to the same number of rows that Table1 has whenever data is added??