If I understand your plan it will not work. You have to support from below, Your wall that you want to remove is supporting the load.
Here is how to cut a hole in existing wall for a door or window. The basic premise may work for you. Just think of your opening as a big doorway.
You will need a big header, probably something engineered. A good lumber yard should be able to help you with that (usually not a big box store)
Cutting opening in Load Bearing wall
Becasue you will not have any plywood on this wall nail a 2x6 flat on the top and bottom to act as a stop. (hopefully will make sense once you read the link.)