Trying to auto-populate varying options based on selections (Perhaps not possible)

I have a spreadsheet that is used to track the commission paid out to photographers, and am hoping to streamline the data entry process by assigning commands but am not sure if it's possible.   An ...