I have a spreadsheet to check which products are being sampled but instead of
having seven different sheets for each day i just want one sheet.
example

A1 Will have a drop down list with days of the week

Received sampled
Percentage
A5 High risk products 100 0
A6 Medium Risk Products 20 0
A7 Low Risk Products 10 0


I want to be able to pick the day from the drop down list in A1 and check
the totals without having to continuosly check different sheets (so by
selecting monday it will bring up mondays data to be edited or checked , then
tuesday wednesday etc)

Hope this makes sense to someone

Thanx for any help