Multiple pricelists

We currently have 200 odd price lists that each has macros in it to update when there are increases and decreases. This is only done in groups and we now need to change this to be able to update a master price list linked by a percentage to all price lists and the ability to update all cells at once, certain rows at once, certain columbs at once, and the ability to update prices vertically and horizontal. 5 Columbs of pricing is what is needed.