Merge Data from Multiple Worksheets with Duplicates

Hello,
I'm looking for an easy way to solve a problem I have. I'm working with someone to teach me a way to do this by converting the information into a MySQL database and process it using PHP, but I'm getting a bit confused an was hoping that I could try a different solution here.

I have a spreadsheet that includes five worksheets (tabs), there is a "Main" worksheet that includes the title, description, function, release date, expiration date, filename, business owner name and author e-mail. These eight columns represent eight properties of a piece of content. The piece of content is always primarily defined by the title.

There are four other properties that are assigned to each piece of content. They are represented in each of the other four worksheets (tabs) in the spreadsheet. These properties can have multiple values and in some cases, a title may not have a property assigned at all.

I'm trying to combine all this data so we can more easily complete a manual migration of this content. I'm going to have a data entry contractor enter the information for each content item.

I've put together an example of what I will have to start with, and an example of the results.

Start with this, looking for this.

Any help would be appreciated!

Steve