Create a system to load different scenes for different projects?

Hey all! I wasn't sure where to post this question so I hope it is in the right place. I started a new position at my work and we are looking at trying to use Unity for some production (I really hope we do!) which would be very handy for our company. Its a manufacturing company and we are hoping to use unity to help build and inspect, we already have some programs that work but Unity seems so much better from our tests.

The problem that is facing us right away is when we want to create multiple files, one for every item being built/inspected, but pull them up in a single program. Essentially we want to be able to create build instructions and inspection steps, but we don't want to have to build a whole new program for every single item.

Is there a way to create one Unity program, but be able to pull in any scene or project into that? Can we just use different scenes or is it more involved in that? Does unity provide any type of cloud service that would help us?

Any info would be great, thanks!