Can I have my code (that updates data on sheet("Materials") to automatically
activate when the user selects that tab in the list of sheets?
I tried this:
Sub Worksheet_Activate()
Update_Materials
End Sub

where Update_Materials is the sub to do the work, but nothing happens when I
flip between sheets...