Thank you so much for your response.

I would also like to ask, is it possible to make row 1 in sheet2, automated, for example to extract the names and prices from sheet1 automatically in a list format instead of manually adding it in.

thank you for your help and time.