REF Table connecting multiple into calendar to see all dates

[Kimberly_Lopez]

Hello
Im trying to connect 3 sheets data into one sheet Calendarview. I set column “Appointment Date” as a key in all sheets and used a column “Type” as the ref type within the Calendarview sheet. I tried using the IF to determine whether the Type input matched the name of the TYPE sheet which would be for example “Blue, Red, Green”.
But not sure which way would be best to connect sheets into one sheet. Not sure what Im doing wrong…

[Steve]

Kimberly_Lopez:

Im trying to connect 3 sheets data into one sheet

What does this mean?

[Kimberly_Lopez]

Hello
So I have four tables and want to be able to see three table data in the 4th table as a whole is that possible?