Merging Worksheets

[kpark91]

Hello,

So, it's been a month since I started VBA excel
and I am trying to merge 2 worksheets into an already created new worksheet in the same workbook.

Worksheet 1 has 51 columns/parameters
Worksheet 2 has 53 columns/parameters
They have 42 columns/parameters in common.
First row shows the parameter's name
After that, data is written.

Worksheet 1 has 428 data rows (not sorted)
Worksheet 2 has 304 data rows (not sorted)

Now on a Worksheet 3, data must be entered correctly into its own parameter column while checking if the data from 2 worksheets are the same. (If not, where is the problem occurring?)

Well, I haven't started programming it yet but I do have a good idea how to do it. The only problem is that I might have to use nested loops which may be run 428 * 304 times and checking the data 428 * 304 * 42 times whether they're the same!!!

To all excel gods out there, could you give me good ideas or at least the part of the solution in how to do it?
*Bow*

Thanks in Advance!!

Edit: I am using Excel 2003 in Windows XP