Hi, it seems that you want a VBA coder to write a script for you, we can easily do that by using VBA and connect it with google spread sheets using google ApisVBA library.
I have 2 certificates in VBA and I've already worked on two projects in VBA one was to create a full tracking sheet for a production line and the other one was to create a full data entry user form.
I am just asking you to send me any sample of the sheets we need to work on
I will be very happy if you contacted me to work together, thank you.