Ok I'll try this differently and hopefully someone will get what Im trying
to do.

Currently I am using a spreadsheet it's called a Want Load Sheet

Guy comes in and puts in the Want Column qty he wants for next week's load,
this is the only inputted column
The spreadsheet contains about 50 macro's and is getting way out of hand.
WA is linked to the previous weeks sheet, ADD is (Count - WA), Count is QOH,
Out is what was loaded last Week and In just calculates the count/Case qty

The guys who use this Spreadsheet use the computer once a week and only
input Qty's in the Want Column, everything else is historical data that they
use to figure out what they might want to order.

I have this WB Split up for 3 different Branches with 25 different sheets.
Access just seems lilke the next step to take, I know how to do the tables &
querys to get the reports to generate but the form so these guys can see
historical data and input what they want has me pondering.

I have consulted warehouse staff and it's mandatory they see all items to
scroll through.

                                                      WA   ADD
Count         OUT         IN         WANT
           18/Superloaded                    4        3                16
4            1                4