I have and am currently using importrange to pass data back and forth between separate google sheets. I plan to bring it all back into one sheet once I clean some things up, but it seems to be working for the most part. The only thing is you are not guaranteed to have the information updated instantly within Glide once your main sheet pulls in the data from the second sheet and some say this doesn’t work when the sheet is closed, but I’m not completely sure. I would say it’s potentially possible.
Would it be better to grant authority to your client to update the values within the app? Maybe show an entry field for them only and a basic text component to show the price for everybody else? Then updates would be instant and you wouldn’t need a second sheet or have them access a spreadsheet at all.