Retrieving data from multiple worsheets to single worksheet

[Ajitha]

I am completely new to Excel macros.If anybody could help me on this..that would be great.Thank you.

I have two different folders

Folder 1:With BOD( worksheets from client which can be in any number)-Format1
Folder 2:Invoice(Single Worksheet where i should group all the details from BOD worksheets)-Format2

Please find the Worksheet formats attached.

Things to do:
1.B3 (Format1) to A12(Format2)
2.J&Q13(Format1) to X12(Format2)
3.A,B,C,D,E,F,G,H,I,J,O,P,S,T,U27(Format1) to B,C,D,E,F,G,H,I,J,K,P,Q,T,U,V12(Format2)

This should happen for each and every row in Format1 and and each format1 in folder 1.

Any ideas would be much appreciated. thank you.