<div>
The easiest way is with a formula pointing to the file /worksheet / cell 
<pre><code id="code-8205946">='C:\Users\userName\Documents\Temp\[Budgets.xls]2012 Budget'!$B$1</code></pre>
</div>


The easiest way is with a formula pointing to the file /worksheet / cell

='C:\Users\userName\Documents\Temp\[Budgets.xls]2012 Budget'!$B$1

<div>
I am sorry I am not an excel person could you please break this down for me in steps what I must do and where I must use what you have provided above
</div>


I am sorry I am not an excel person could you please break this down for me in steps what I must do and where I must use what you have provided above

<div>
R8VI,<br />
<br />
EE star and Microsoft MVP brettdj covers how to do this in his excellent article here:<br />
<br />
<a href="https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2804-Code-to-compile-all-worksheets-from-either-a-all-Excel-workbooks-in-a-folder-or-b-a-specific-Excel-workbook.html" rel="ugc">https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2804-Code-to-compile-all-worksheets-from-either-a-all-Excel-workbooks-in-a-folder-or-b-a-specific-Excel-workbook.html</a><br />
<br />
Patrick
</div>


R8VI,

EE star and Microsoft MVP brettdj covers how to do this in his excellent article here:

https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2804-Code-to-compile-all-worksheets-from-either-a-all-Excel-workbooks-in-a-folder-or-b-a-specific-Excel-workbook.html [https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2804-Code-to-compile-all-worksheets-from-either-a-all-Excel-workbooks-in-a-folder-or-b-a-specific-Excel-workbook.html]

Patrick

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have about 50 odd excel files in one folder <br />
I want to create 1 spreadsheet with all the data they all have the same headings <br />
<br />
Please help <br />
<br />
Thanks,<br />
<br />
R8VI
</div>
</div>


Hi, 

I have about 50 odd excel files in one folder 
I want to create 1 spreadsheet with all the data they all have the same headings 

Please help 

Thanks,

R8VI

Excel Spreadsheets having as one

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.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.