VBA excel grab macro

[eranfox]

...

The information in each data file needs to be copied from row 3, column A until end of data, and the pasted AT THE END OF ANY DATA in the master file starting at column.

For each of the data files' data; In column A I need the date created from the properties information. In column B I need the time created (to the minute) from the properties information. In column C I need the data in cell E2 of the data file to also be copied next to that files data.

...

Hello njohnston,
Welcome to the VBForums.com
for a start, where is the button placed? in the master excel file or in any other file?
do you know how to record a macro? ths can be very helpfull for you when you'll build your own macro.
do you have one workbook or 50 as you mentioned?

Range("A3").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Range("D3").Select
    ActiveSheet.Paste

this simple macro copies all the data from row 3 col A to col D starting from row 3 in the same Sheet...

Is that you need for a start?

Best Regards,
ERAN