Enter Table name in cell?

Hello,

I have a complex question that I am not sure is able to be solved.

I am using an Excel file with 2 sheets, calling them A en B here.

In sheet A, I have Table 1, 2 and 3. In sheet B, I have Table 4. Table 4 is the table that collects all information from the 3 tables in Sheet A and puts them together in 1 table.

I want to know whether it's possible to display the table name in a specific column in Table 4, depending on the match it has with whatever one of the three tables in Sheet A. So for example,  if a row in Table 4 correlates with the information mentioned in Table 2, it should say ''Table 2'' in the cell. 

I hope my question is clear.

Kind regards,