Hmmm, welcome to the forum, but I suspect messing with this stuff with limited technical knowledge in Strength of Materials, you may well soon be an exploded Engineer. Making things that use explosive propellants "bigger" is working towards bigger material failures.
Only an idiot would take advice from faceless but well meaning folk on the Internet to build such a device without Professional, well qualified and experienced Engineering help. You and your grandpa have been lucky so far. The cost of gears and propellant will be a minor issue compared to the Hospital costs.
Try this on Google...
potato cannon explosions
If that serves you no good, then try this...
homemade cannon explosions