Screen on/sleep button won't work

Yeah of course, it's not a ribbon or flex that you can unplug and plug back in, its simply going to need to need to have the power button re-soldered or replaced. If you don't have the the equipment or knowledge on motherboard repairs I would take it to a local repair shop since this is delicate work that has to be done directly on the board, and a wrong move can cause serious complications.