Consolidate Columns & Remove Duplicates

I am trying to figure out a way of combining the contents of columns from four worksheets (project numbers, B5 to B24) into a single column on a fifth worksheet (project numbers on Totals worksheet). It also needs to remove any duplicates. I have tried using excel functions yet haven't been able to find anything that will fit my needs without becoming unwieldy. I figured a VBA macro would be able to do what I'm after but dont have any experience in VBA programming.

I have attached the file just in case my explanation left a bit to be desired.

Time Sheet NEW.xlsx

Any help would be great.

Thanks for the reply and welcome Sixthsense.

In the first four worksheets under the 'Project Number' columns people will enter various job numbers. On the totals worksheet in the 'Project Number' column I need a summary of every number without doubling up. So a list of 1 2 3 4 5 6 7 instead if 1 2 3 4 1 2 3 4 4 5 6 7 4 5 6 7. I have entered it into the file attached for clarity.

Time Sheet NEW_1.xlsx

Each project has a unique number associated to it. The four people (first four worksheets) enter the numbers of the projects they have worked on. More than one person can work on the same project. The last worksheet (Totals) is a summary of all the projects that have been worked on and then breaks down how many hours have been worked by each person on each project.

The 'Project Description' column works already, it looks at the project number, cross references another workbook and pulls in the name recorded for that project number. All I am after is how to get the 'Project Number' column to give a summary of the projects everyone has worked on without doubling up entries.

Thanks again for your replies.

Wow, thanks that is just what I was after.

What would I have to do to the code to not have the cell formatting, styles and borders come through to the 'Totals' worksheet?

Also each month the reference area is going to have to move down 30 rows. Would it be possible to connect a drop down box on the totals sheet to select the required month using your code?

Ideally on the 'totals' worksheet cell B2 will be a drop down (combo box?) where you can select the month which you want a report generated for. For example, click on cell B2 on 'totals' worksheet and select April '13, it would then retrieve project number ranges from cells B35:B54 on the other sheets instead of cells B5:B24 as it does now. That way you could create a report for any month without the need to revise the code every month. Does that make sense?

I have attached a version of the workbook with comments in orange to try and explain it better. I hope it helps.

Time Sheet NEW_2.xlsm