Your descriptions remain confusing.
It did not help that you used false data in some of your posts. This results in different posts referring to the same item withe different names, such as Sheet1 and a worksheet named "actual data" (or "ACTUAL DATA")
You have said: Copy cell A3 AND LAST CELL OF Column E:E in every "ACTUAL DATA" worksheet TO add a new worksheet but you then say i need to copy cell A3 and last cell of column E:E for every workbook that i attempt to open and paste it to a new workbook.
Do you mean that you want to copy - in each opened workbook that contains a worksheet named "actual data" - cell A3 and the last cell in column E and then paste them to a new workbook - or do you want to paste them to a new worksheet in the workbook that contains the macro (i.e. a new worksheet each time you run the macro, or do you want to paste them to one worksheet in the the workbook that contains the macro, and create a single master workbook in the workbook that contains the macro.
In your last post you introduced for the first time a workbook named 1234.xls.
Is 1234.xls the workbook that contains the macro.
Is 1234.xls a real workbook name or just one you made up.
Do you want to create a different workbook to save results in each time - such as 1235.xls and 1236.xls
Can you explain what you mean by the worksheet where my macro is at always exits
When does it 'exit'. Do you mean that the 'workbook' that contains it exits (closes).
Please use real information in your reply.
Please re-read your reply before sending it to make sure that the information is accurate, including the correct use of the terms workbook and worksheet.
As I am sure you know, programming has to be very specific. If the program refers to a workbook, then it will not work 'as expected' if it should have referred to a worksheet.
My current understanding is this:
You have a workbook (but I don't know its name)
This workbook contains the macro
and it contains a 'master' worksheet that consists of the data from two locations in workbooks containing worksheets name "actual data" that you have opened (cells A3 and the last cells containing data in column E).
and it contains copies of the complete worksheets named "actual data" from each opened workbook that contained a worksheet named "active data", with the copies of these worksheets named with a sequential number: "actual data xx"
After adding the data the 'master' workbook is saved and closed.
At the ed of the process there is one 'master' workbook containing copies of the 'active data' worksheets in many Excel files that you selected and a single worksheet containing the A3 and column E cell values.