Combine worksheet one after another from folder

[DocAElstein]

Hi sachin482,

...can it be done...

It can almost certainly be done , and there are probably many ways to do it.

Here some general help to get you started:
_1) I would probably start by reading up on the
VBA Dir Function
Try a search with something like " Dir Function Loop Through all Files in a Folder VBA "
You can easily loop through all the files in a Folder using the Dir Function

_2) Then I would use the macro recorder to open two of your files , open a new File, and do all the operations that you wish to do.

It should then be fairly easy to modify the code which the macro recording gives you such that it does exactly what you want to do

_..........................................

For more specific help,

_(i) Upload two typical Files ( Desensitize the data if necessary ).
_(ii) Explain again in as much detail as you can, exactly what you want the code to do.
Alan