Populate table from another table based on drop down list selection

[Ashleimo]

Essentially what I am trying to do is copy a table from one worksheet to another based on a selection from a drop down list. I would like for each time the drop down option is changed the table is changed.

For example:
Worksheet1
A1=Quarter 1 (Chosen from drop down list)

A2= Table named Quarter 1 pulls from Worksheet 2

Hopefully that is clear. I'm open to all options!

 

[Ashleimo]

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 5-24-18 6:45 PM EDT
If Not Intersect(Target, Range("A1")) Is Nothing Then
Application.ScreenUpdating = False
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
MsgBox "Hello now I will look for a Table named  " & Target.Value
Dim ans As String
Dim x As Long
x = 0
ans = Target.Value
Dim TT As ListObject
ans = Target.Value
    For i = 1 To Sheets.Count
    
        With Sheets(i)
            For Each TT In Sheets(i).ListObjects
                If TT.Name = ans Then
                TT.Range.Copy
                Sheets(1).Range("B1").PasteSpecial xlValues
                Sheets(1).Range("B1").PasteSpecial Paste:=xlPasteFormats: x = x + 1
                 Exit Sub
                 End If
                 
            Next
        End With
    Next
    If x = 0 Then MsgBox "I found no table named  " & Target.Value
Application.ScreenUpdating = True
End If
End Sub

GENIUS! Thank you so much!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

GENIUS! Thank you so much!