Consolidate specific worksheets residing in multiple workbooks in folder into one single worksheet

I have a folder named (BAKING), which has about 30 workbooks. Each workbook has 4 worksheets, out of these worksheets I'd like to extract one worksheet (IS DIFFERENT IN EACH WORKBOOK)  and then consolidate into a single worksheet.

starting at row 2 and ending with the last worksheet
MATO0618Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ProfessorJimJamConnect With a Mentor Commented:
the easiest and best solution to achieve what you described is using free Add-in from my friend, Ron de Bruin

http://www.rondebruin.nl/win/addins/rdbmerge.htm

rdbmerge.png
1
 
Robberbaron (robr)Commented:
as i see it, the biggest issue is "(IS DIFFERENT IN EACH WORKBOOK)  "

how do you or user manually chose which worksheet to extract ?  there must be some methodology behind the selection.
0
 
frankhelkCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: ProfessorJimJam (https:#a41861767)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.