VB Code to Copy & Paste based on Excel Column Value?

Hello,
I am needing help with creating a macro to sort a document downloaded from PeopleSoft each morning (read only), and placed into an excel template document based on a column's value. I have attached an example excel document ("MacroHelp.xlsm") with data I am needing to extract.

As you can see in column E ("Method"), there will be either 'ACH' or CHK'.

If column E shows 'ACH', I would like to copy all of the data (Column A through Column G) and place it into a different document already created (see attachment 'T&E - ACH Template.xls').

If column E shows 'CHK', I would like to copy all of the data (Column A through Column G) and place it into a different document already created (see attachment 'T&E - Check Template.xls').

These templates are reused everday. Meaning, once these templates are filled in correctly with their data, I print and close without saving.

Thanks in advance for any help you can offer!

Mike,
That worked beautifully - many thanks!