Improve Inventory database - Mimic/Link/clone cell text for another cell

DianezP If having the data you're consolidating reside within a table object is a primary requirement, dynamic arrays will not work.  PowerQuery can provide an alternate solution.   You could use data/refresh all to pull in the part master data, delete any unneeded columns for that tab & "load to: table" for as many tabs you need.  This will eliminate the requirement to manually enter new parts on every tab.   You can add more columns to each table which will similarly expand with every new part added in the part master. 

In the "Data" menu, use "From File" or "From Text/CSV" if the part master resides in a network folder.  Or use "From Table/Range" if you want to use Table1 on the database tab as the starting point.  

Lastly, if you don't want to press refresh all when new parts are added, the query properties can be set to "Refresh data when opening the file".   This can be annoying if you are opening the document several times/day, but it's an option anyway.