Hi all,

Thanks for reading my message. I'm new to the forum and also very new to using spreadsheets on a daily basis.

For my first cry for help I'm afraid I may be biting off more than I can chew but here goes:

As my topic title suggests, I'm want to take a bunch of standardized Excel files and copy their contents over to a "master" spreadsheet. So for example on the Master file, I have a column labelled "Project ID". On all the individual files, Project ID is always located on cell A20.

How would I go about creating a formula or macro that I can trigger that just grabs the value of A20 from any given file and copies that value to my Master spreadsheet?

Would appreciate any tips or pointers on how to get started on this.

Thanks in advance!