Why would a Monte Carlo with a 4t60e transmission only work if you shift the gears manually?

Well the first thing to check is the vehical speed sensor (VSS), does you speedometer work? If that checks out ok, take it to the trans shop for an estimate usually not that much, and often times free.