VBA to copy data from specific cells from multiple identical workbooks into master sheet

[annafd]

Hello everyone!

I have the same workbook that looks like a form with only one sheet but the data changes from a workbook to another, and I need to transfer all the data from approximately 40 workbooks into one Mastersheet.

Example:

Name:	Anna
	Surname:	BB

Following this example, the issue is that I have Anna in one cell, the BB in another, and so on. (Because of the formatting of the form and cells merging, image an excel invoice).

Could please someone help me with the code where I can pull out the data from all these workbooks (that are found within the same folder), and I can indicate the cell where the data is located and the cell where that data needs to be exported? I've found this post which code works great but I am unable to select each cell, instead I can only select a range:

VBA to copy data from multiple workbooks into master sheet

Hello Everyone! I have to copy data from 10+ workbooks and paste it into a master workbook. All the workbooks are located in a folder on my desktop: C:\Users\xbv\Desktop\group1 All the workbooks contain a sheet named 'appendix B', I have to open each workbook, go to sheet 'appendix B’, select...

www.mrexcel.com

I also need to export this data having the workbooks closed.

Great if someone could please help me with this one.

Thanks

 

[annafd]

Hi again,

I am attaching an example, showing how I would need to export from D7:D11, C13:C15, E13:E14, and so on... And that would be imported to the Mastersheet being the first row the titles and the following rows the data exported from each worksheet. Please note that some values are from a dropdown list (data validation) but I hope that is not an issue.

Thank you again!