Moving Data from One Workbook to Another Workbook

[abutler911]

Hello All -

I am sure this is an easy thing to do but I am trying to get these two workbooks to interact with one another so that data from the first sheet (TEST DATA SHEET) is pulled from the workbook and inserted into the workbook (TEST INVOICE AND SUMMARY SHEET) in the next available row based in the month of the year. Basically, I am trying to capture all the entries in the first sheet during the month of July and insert the data into another sheet as a sort of summary, then for August, September, etc.

Hope that makes sense. Thanks in advance for any help.

Andy