Create Search/replace feature and freeze at top of screen

So first off I'm working with about 1,000 unique data entries, I want to create a separate sheet where I can enter a persons name/DOB insurance, case manager, and phone # and press a button to have it search the sheets and update the contact into if anything has changed or to add a new entry to the correct page based on the first letter of the last name. names will be entered in a Last, First order. and secondly I would like a button to sort the sheets automatically alphabetically. and then lastly If possible I would also like to enter in the last time there paperwork was turned in have a check to see if it has already been entered in and if not to move 1 cell right of the most recent entry and put the data in. I'm sure if the last one is possible at all though.

I believe this might be a Vlookup thing but its completely out of my realm of understanding as I hadn't even heard of Vlookup until about an hour ago, If anyone could let me know if these things are possible, point me in the right direction, or help me out with it Id much appreciate it.

I've uploaded my practice sheet which is as close to possible to the current form I'm using.

My 1st question would be - why the need for that many sheets? If you have ALL your data on 1 sheet, it makes doing things like this SO much easier, finding what you want can be done with a very simple formula

Double post

Originally Posted by 33CDonnelly

patients names are sorted alphabetically by sheets, just makes it easier to find them rather then scroll through a couple hundred cells.

Actually, not really. With the right search function, you can find what you want real quick

Well if you have all info on 1 sheet, and you wanted to find a name, you could use a drop-down, or enter the name into a cell and have vlookup or index/match pull the data for you. To be more specific, I would need to see a (clean) sample of what you are working with though.

ok, ill work on creating a clean sheet for this one. and my hopeful goal if its possible is to freeze the 2nd row of cells so that I can enter in a persons name/dob/and other info. press 1 button to search for them. and another to update the info or add the patient if they don't currently exist. but not to update a cell to blank if there's currently information already entered for that cell.

If its not possible to do the search feature on a locked bar then a 2nd page would probably work best.

Anyone have an idea if this is possible and how I would have to go around it?