Comparing Price Lists

Is there an easy way for me to compare the pricing of my competitors that they publish on their websites?

Right now, I print out all of their pricing, and then log everything into a spreadsheet by hand, then compare pricing, and determine where to rank mine...... when looking at over 200 line items, and 5 competitors, this is a process that definitely takes quite a bit of time. I have attached a sample of what the file looks like after i do it all manually.

Please let me know your thoughts.

Thanks!

sample.xlsx

Thanks Chris.

If the format of other companies pricing sheets are different from my formats, I would still have to link everything together right?