Copy 6 Worksheet Patse To Totalsheet By The Last Row

[pichai]

Hi,any person can help me with the excel macro VBA code for copy 6 sheets to the new worksheet name(total of 6 worksheets ) in the same workbook.
I have 6 worksheet(A),worksheet(B),worksheet(C),worksheet(D),worksheet(E),worksheet(F) .The data in that 6 worksheets as the same format begin in column A1 of row A3 to the colum F1 rowF3
this 6 worksheets in the cell A1 have the name for the sheet ex.001 in worksheet(A),002 in worksheet(B),003 in worksheet(C),.............

I wish to copy all data of begin from the range B3,C3,D3,F3,G3 of that6 worksheets to worksheet (total of 6 workshets ) by begin at the Row of A7
this worksheet format in cell B2 ,C2,D2,E2,F2,G2 use for key in the
number sheet name of that 6 workseets as 001,002,003......

when the user key in the number of that 6 worksheet in cell B2 ,C2,D2,E2,F2,G2 and run the macro .,
the all data from the begin of the range B3,C3,D3,F3,G3 of that6 worksheets will paste to the worksheet (total of 6 workshets ) begin at the Row of A7 ...sheet 002 in the last row of 001 ,sheet 003 in the last row of 002 ,sheet004 in the last row of 003.....,sheet 005 in the last roe of 004,sheet006 in the last roe of 005 etc.
Thank.

[royUK]

Why have data spread over 6 worksheets/ A well designed workbook should have all the data on one sheet & then you can summarise?report on that data using Excel's database tools such as PivotTables.

[pichai]

Thank,roy UK
yes my worksheet have 6 sheets and one sheet with the total from 6 sheets
i want the macro code to run by copy from 6 sheets to the total sheet
as the ex.
can you help me ,please

[VBA Noob]

See if this link gets you started

http://www.rondebruin.nl/copy2.htm

VBA Noob