|Right Click the Sheet tab for the sheet with the dropwdowns.|
Choose View code
Paste this code into the pane that opens:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Application.CutCopyMode = False
When B1 is changed via the dropdown, A1 will be copied to A1 of the page whose name appears in B1.
As written, if you pick a name that should be copied to Hospital and Hospital is already displayed in B1, it will not automatically copy A1. You would need to pull down B1 and select Hospital again.
If that is an issue, then come on back with more specifics and we'll see what we can do.