Hello - new here, and I reviewed a number of posts on this topic, but couldn't find one that really fit what I was trying to do...

I have five team members managing projects, each with a variety of print deliverables they are developing. Rather than having them update data in two different places, I figured I'd have them update their own tabs in a Spreadsheet, and then create a master which combines all of their work into one place - which I could then sort, or provide to my supervisor for an overview.

I have developed a worksheet/tab for each staff member, and they have matching columns and column headers (A1:M1). Some are managing more projects than others, so while one staff member might have only three rows of data, another might have 200. There are no...