How to Automatically Update Multiple Tables in InDesign from a Single Excel File

One thing you will need to test will be what happens when you add or remove rows. If you add rows in the middle area of the data, the named region should expand automatically; if you add the new rows to the top or bottom, you will have to manually extend the range. 

Depending on where the data originates (Excel or from a database), more advanced options would be database plugins. They can either import the data and update or even have a live link to the original database for seamless updates. Companies include Em Software, Teacup Software, and 65bit.

If you want this data to be split into a separate Tables in InDesign - you won't be able to just use DataMerge - unless, you'll split one long table manually.

What would be the "key" - data in which column will be the "signal" to split data into separate tables in InDesign?

Anyway, you'll need some commercial product to do it - if you want to be able to update prices.

Then there is a case of how this 3rd party tool will know where to place those separate tables?