Copy paste from id to west column table data onto output sheet using vba

[globalsourcing]

i've three table in each sheet. manually i need to copy each sheets third table data into sheet called output from id column to west column.
the ID and west column number varies in each sheet.your help is appreciated. sample workbook is attached.

[walruseggman]

Please Login or Register  to view this content.

[globalsourcing]

your help is deeply appreciated.any chance you could insert row and add sum formula for each table that will sum north,west,south.
sample is attached.thanks again for your time.

[walruseggman]

I just did the summing in the code instead of a formula on the sheet, hope that's ok. If not, just ask.

Please Login or Register  to view this content.