Setup Internet Connection Sharing on the computer, run the setup wizard for that on the other computers. Change the binding order for the network cards so that the cell modem is second after the ethernet connection.
I don't know how automatic the switch will be, but that should enable the computers to find the connection when they can't connect using the primary one.