We have a master project number generator in Excel for all of our businesses. We would like to add an extension to the master number for the individual business for each project if that business is involved. Not all businesses are involved in all projects. We would like to end up with a single list at the end (I have attached a greatly simplified Excel example (ignore the formulas I am using, they were for quick example generation). How do I get from Sheet1 to Sheet2?