copy data between two workbooks

How to copy data between two workbooks Files (4) and (M) using VBA code such that the code detects a blank row in the file (M) and then pastes the copied data from file (4). Files (4) and (M) are attached. Thanks