VBA for copying specific cells from many workbooks into one workbook

[Fruity27]

I’m trying to find a vba code that is dynamic enough to be able to be used as new workbooks are saved that I need data from. For example, I have multiple spreadsheets named workbook1 workbook2. Workbook 3 etc.
I want to use a macro that pulls specific cells from sheet 1 from each of these workbooks into one master file. But I want it to be able to continue to work as I add new workbooks - workbook 4, workbook 5, workbook 6.
Any ideas?

 

[rlv01]

I’m trying to find a vba code that is...

Welcome to MrExcel. The desire to have a macro grab some data from some location in some workbook and put it in some other workbook in some other location is a common enough topic here, but you are unlikely to find code that does exactly what you want. The closest you will be able to come is to use the Advanced Search Feature to locate some code that maybe does something similar enough that you can study the VBA code and then modify and customize it to make it work for you.