Retrieving data from multiple worsheets to single worksheet

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.

Welcome to the forum! First, let me ask you a few of questions for clarification.
1. Is the Print Order sheet of the OrderFileMA-4743 what you are calling BOD? What is the Invoice sheet in that workbook?
2. What is J&Q13? Does that mean that you want to concatenate J13 and Q13? Note that column Q is hidden in the Print Order sheet.
3. When you refer to row 12 in Format 2, do you mean the next row on that sheet that doesn't have anything on it?
4. It appears that you would like to process a collection of workbook that are all stored in a single folder. If that is right, are the files all named in a certain way that they will all show up on a search of the folder with no other files appearing in the list?
How much time do you hae to do this? I am asking because since you are new to Excel macros, this could be a good learing experience for you if we take it slowly.

Let's see how well this works for you. I don't have a lot of test data and you may want it to do something a little different so we'll have to fight through this a bit. I've attached the Monthly Template file with some VBA in it. If you run the macro MergeOrders, it will display a dialog that will have a way for you to browse to the path containing the order files. You then press Run to merge all of the order files to the monthly template. It requires that the order files have a sheet name "Print Order".
Monthly Template.xls

Great! The file filter that is in the code is pretty simple - only looking for .xls. You may need to change that as you see fit based on the contents of the folder and the file naming conventions. Note that there is a sheet name restriction as well.

I assume when you say nothing is happening, that your user is pressing the Run button and nothing is happening. The sheet names in the workbooks have to have the name "Print Order" before anything will happen. It ignores workbooks that do not have sheets with that name.

I don't have Excel 2002 so I can't check this out. It is possible that file handling for reopening files is different between the two versions. Stopping Excel and restarting it, then run the macro. That will make usre that all files are closed when you start. Note that the macro ignores errors while opening the workbooks in read only mode.