VBA / Excel Formula to extract and update the data from worksheets

[monteee]

Hello everyone, I am trying to create an excel which enables the user to retrieve the data from “NY” and “LA” worksheets per user’s criteria (Customer ID) in the “Update” worksheet and the user will be able to update the record (i.e. “Assigned” column) saved in "NY" and "LA" via the "Update" tab. I have tried to user the “Filter” function, however the function is not available in Excel 2016 and could not update the "Assigned" column via the “Update” worksheet. Can someone please help me? Thank you in advance for your assistance =)