can this be done?

[tim_p70f9]

Hi All,

I have a few questions of weather this can be done in excel 

the idea is to track the status of items. 

my idea was to have sheet 1 as an input sheet to add a new item to a master sheet so on button press add new row.

then several other sheets would show a pre filtered views of the information with a final sheet being able to make changes to the status 

the idea is for there to be as few as possible options for users to edit or have to change to see the requires information 

Any ideas 

Kind regards Tim

[#2]

@tim_p70f9 

Which version of Excel do you have?

[#3]

Hi Patrick Its 2016

Kind Regards Tim

[#4]

@tim_p70f9 

Attached a rudimentary sample workbook.  This method will pull the rows without a need to refresh.  You could run a pivot but then you'd have to refresh it as needed.  If you had 365 then you'd have a few more options.

[#5]

Wow that’s good I’ve a few questions where does cell a1 get it’s values from?