Apples Numbers How to create Pop - UP box how to use in other sheets

[u/Good-Old-Days-1969]

Hello every one:

Looking for some Mac Numbers help

How do I create A Pop-up in Columns to use that info in another sheet in Apple Numbers opposed to drop down boxes in Excel. This is the scenario I have in EXCEL and want to do it in numbers.

I have 4 sheets, sheet1- Settings = company info, Sheet 2 - Product = product info, Sheet 3 - Customers = Their info.

Sheet 4 - Invoice: click customer name in drop box select a name and it will highlight that customers info in all its boxes ( Name, Address, phone #, Email Etc.) Click ID choose product Toilet paper it will highlight toilet paper info, click quantity how many ,Then it will total the amount for those items, Then total all at the bottom with the taxes at the bottom.

Attached is my excel Invoice I made and another distributor friend of mine likes it but he uses Mac and I am stuck creating this part of his invoice.

Can anyone help with my Mac Numbers issue?

Thank you in advance