Order Guide Is it possible

[Jackson84ss]

I run a kitchen and have an order guide from a supplier that I download from their site into excel. It pulls that data from that sheet and places it on another with ordering build to's. Is there a way when a new item gets added in the middle of the guide that it adds a row and pushes everything down? The build to's have to be editable but also locked to that specific product on the order guide. Otherwise what happens it copies it to that other sheet but pushes all the pars down and have to go through the whole sheet to edit. Thanks in advance