Inventory and Invoice Management

Hello,

I'm trying to set up my client invoices to automatically fill the prices from the my inventory sheet (and change the inventory?) Is this possible to do in Excel? I'm using Excel version 15.4 on a mac laptop.

Thank you