Back when beer pop cans were made of steel we made hundreds of those:
From the base up -
Can #1 - punch a small hole in the side near the bottom, and use a church key to add five holes to the top (six including the tab hole)
Can #2 - with a church key make six holes in the bottom and add five holes in the top
Cans #3 & #4 - cut both top and bottom out.
Duct tape the cans together.
A little lighter fluid down from the top, and swing the cannon around to coat the walls; drop a tennis ball in; a good squirt of lighter fluid in the side hole; and light. More lighter fluid was no good, except for flame show, unless you added more cans (our record was a total of 10 - three in the base chamber and seven to form the tube); and at night you could track the flight by the burning fuzz on the tennis ball.
The nice part about the steel cans is that the rims gave strength to the tube with minimal duct tape. Outside of the joy and motivation of emptying the cans, these rednecks would have been better off with pvc.
I don't know how many of these I made with friends, the Buena Park Parks Dept. kept taking them away from us. However, unlike "old seven fingers" in the paint can video, I still have all ten fingers and the only hair I'm missing is of natural causes.