Hello,
This is my first post here.

I have many workbooks, each with various number of sheets.
Each sheet has two columns I need to cut and paste into a new workbook.

I need to append each new cut and paste to the bottom of each old cut and paste. So I am basically stacking the data from the sheets into this new workbook.

Is this possible?

I appreciate any advise.

I have read that I should load my books for people to help me, but my work has told me the data is proprietary, so that would be a big violation I can not do. I am hoping there may be a general formula I can utilize and adapt. A template of sorts.

To recap: I have Workbooks 1,2,3,4,...n
Each workbook has sheets, 11,12,13,...1n
each of those sheets has two columns (A,B) that I need to cut and paste into a new workbook.

So the new workbook would have one sheet that had all that new info and it may look something like this:

11A, 11B
12A, 12B
1nA, 1nB
2nA, 2nB

Thank you