Split Values From TextBox to Open Sheet by VBA

Hi Friends

Urgent Needs

I have Input sheet with LoginPageSheet1 and Data Sheet2.

In Textbox if I enter value of column A:A of data Sheet Its Open New Sheet With Name of Unique value of Data from Data.sheet1.


I have enclosed two sheet Pls FTA if you help i really grateful to u

E.G if Enter Store1 in TextBox .then Split Only Values of Store1 of Multiple data in New tab with Name of (Store1)

Then If Make changes in New Opened sheet(Store-1) It will save to new chances into (Data)Sheet file.

thanks alot for all support