Copy to Invoice

[Codge]

Please could anyone help.

I need to prepare an Invoice for goods for a small business

I have 5 separate sheets in a workbook,each sheet has a different set of formulas.
Data, Doors, Products, Decors and Invoice.
What I am trying to do is select the input data from the Doors,Products and Decors sheets and enter it ito the Invoice.

I would like to find an alternative method to copy and paste data from each sheet into the Invoice

Thank you


Please find enclosed attachment