automating invoices?

[mrpowwow]

Hi. Each week I receive over 40 invoices in an excel template.

I spend a good portion of time compiling the data from the invoices to get a break down of employees and their weekly hours compared to their output.

I don't have any experience with automation.

What are the first steps I'd need to take in order to get this process streamlined?

Is there a way to import all the invoices at once and create a new file of sums?

Many thanks!

[yawnzzzz]

It would probably help to see an example invoice.

If the invoices are the same, you could put all of them within a folder and write a macro that could open each file and pull the information you want from it. If you've never done a macro before, it might be very difficult for you to do this though.