Question:

In Spreadsheet A column F, I have a list "cars, boats, homes". Column G
allows individuals to put the value of the car, boat or home.

I would like the following to occur:

If a person clicks on cars, then the dollar amount would automatically to go
Spreadsheet B in a predetermined column and roll. And if that same person
clicked on boat, then that dollar amount would go to Spreadsheet C to a
predetermined column and roll.