Merging data from different excel sheets into one new sheet

Hi,
I want to merge data from different sheets.
I've come across several problem and i have done some "work" on it, but i'm unable to go further in the resolution of my problem.

Here is the code that i've made and that is working for now

Please Login or Register  to view this content.

I've joined the output that i want, the code that i've mentionned above would be ran from the first page, that will contains some options if needed, and some information regarding the macro usage.

If anyone could help, this would be great.
thx in advance,
Regards,
MrCarembole.