<div>
Probably a macro is the best way.
</div>


Developer

Murray Brown

<div>
Hi. All the files are in Excel and I want to build this in VBA
</div>


<div>
Can you upload two or three source files for testing. The files should have minimal/fake data but should fully represent the actual files.
</div>


<div>
Hello again<br />
Seeing no action on this question I kindly remind you that Without a sample file, I am afraid it will not be an accurate working solution.<br />
<br />
In case you are still interested please advise.<br />
Regards<br />
Gowflow
</div>


<div>
<div class="content wysiwyg-content">
Hi. I have to pull data into a separate master Excel file from a number of files similar to that shown below.<br />
The source file names are constantly changing so just putting a formula into the destination cell won't work. Often more than one number has to be added up too. What is the best way to do this? Thanks<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/03_w14/1448236/Image1.JPG" target="_blank" title="1 (145 KB)"><img alt="1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/03_w14/800_1448236/Image1.JPG" /></a>
</div>
</div>


Image1.JPG

Hi. I have to pull data into a separate master Excel file from a number of files similar to that shown below.
The source file names are constantly changing so just putting a formula into the destination cell won't work. Often more than one number has to be added up too. What is the best way to do this? Thanks



Excel VBA populating oe master file from multiple source files

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.