Will it work? Yes.
Will it work better than what you have? Not necessarily.
VHF and UHF signals are primarily line of sight. If your antenna can see their antenna, chances are you will receive their signal.
Putting the antenna down in your home, behind electrical wiring, possibly cast iron drain pipes, phone lines, heating ducts, foil backed/vapor barrier insulation, and then put a bunch of noisy electronics around it, like LED lights, TV's, WiFi, computers, etc. is a lot like locking yourself in a room with a bunch of kindergartners on a mix of speed and expresso. All you'll hear is the noisy stuff.
Ideally, you want a decent antenna outdoors and up as high as you can get it. That provides better line of sight.
Getting good coaxial cable between your antenna and your radio helps that signal to where you need it.
Discones are a good basic, all around option. Not the best antenna, but they work well for most hobbyists:
https://www.theantennafarm.com/catalog/diamond-d130nj-5016
I scored it for free many years ago. I put it up at my house as a "temporary" solution. I think that was 10 years ago. Still working well and haven't felt the need to replace it.
As for coaxial cable, that entirely depends on how long the cable needs to be to reach from your antenna to your radio. There are some good basic choices, but I'll refrain from suggesting those until we know more about your specific needs.