Google sheets merge and dashboard

Our FbB management for inventory and costing is not connected to our PoS so i need to import the data to my files merge and get real results.
Plus the costing recipe xls has to be improved and connected to the main costing and pricing .