copy data from one workbook to another but in different sheet?

The problem is I do not want to create a filter because sometimes there will be a manual entry. This a log for transportation and we have dedicated drivers and OTR drivers, would like to import the d...