New tables being created after filling previous ones

Hello, I am creating an Excel spreadsheet to calculate the cost of various parts. The exact number of parts is not known in advance and may vary; furthermore, these parts may be either purchased or manufactured. For this calculation, there are four specific tables—in addition to an initial table that names the part and specifies whether it was purchased or manufactured: Materials, Processes, Transport, and Fasteners. If a part is purchased, it utilizes only the Transport and Fasteners tables; if it is manufactured, it uses all four. Is there a way to have the entry rows for new parts be added automatically, and then—once the user selects whether the part was purchased or manufactured—have the necessary corresponding tables appear? I have looked online but I couldnt ffind anything. Many thanks for considering my request.