Help on Consolidating Data between Worksheet with a Macro

[Learn&Prosper]

Dear All

Need a little help on the following:

I have two worksheets (Say Worksheet A and B) that contain similar data and want to consolidate them into one table on a different sheet (Worksheet C).

Worksheet A contains data in 6 columns (B to I) and X rows (not a fixed amount) but starting from Row 5. Essentially a table of data.

Worksheet B contains data in 8 columns (B to J) and Y rows (a different amount will be populated each time) but starting from Row 5. Essentially a table of data.

There is overlap between A and B --- 5 of the columns of data in A exist in B as well.

Worksheet C contains 9 columns (B to J) and will need to contain all of the data that in Worksheet A and B.

I would like the macro to effectively go down the cells of the 6 columns in Worksheet A and then populate the corresponding worksheet C.
Entries in Column B in Worksheet A to go into Column B in Worksheet C
Entries in Column C in Worksheet A to go into Column C in Worksheet C
Entries in Column D in Worksheet A to go into Column F in Worksheet C
Entries in Column E in Worksheet A to go into Column G in Worksheet C
Entries in Column F in Worksheet A to go into Column H in Worksheet C
Entries in Column G in Worksheet A to go into Column I in Worksheet C

I would like the macro to effectively go down the cells of the 8 columns in Worksheet B and then populate the corresponding worksheet C ensuring that data is not overwritten and populated starting from that row so other data from Worksheet B is populated in adjacent cells.

Entries in Column B in Worksheet A to go into Column B in Worksheet C
Entries in Column C in Worksheet A to go into Column C in Worksheet C
Entries in Column D in Worksheet A to go into Column D in Worksheet C
Entries in Column E in Worksheet A to go into Column E in Worksheet C
Entries in Column F in Worksheet A to go into Column F in Worksheet C
Entries in Column G in Worksheet A to go into Column G in Worksheet C
Entries in Column H in Worksheet A to go into Column H in Worksheet C
Entries in Column I in Worksheet A to go into Column J in Worksheet C

I hope this makes sense - please let me know if its not clear.

I have tried to write this myself but after 3 hours its not even close so would appreciate the help.

Many thanks for looking at this and helping me.

Thanks.