Problems transposing data from a sheet to another

[claustro]

Hi all ,
I have a time table in sheet 1.
This is the only sheet that I change composing the timetable. The sheet looks like this his

date date date
place name name1 name2
place2 name2 name1 name 3

With this formula

=TEXTJOIN("-";TRUE;IFERROR(INDEX(Orario!$A$4:$A$78;AGGREGATE(15;6;ROW($1:$100)/(Orario!C$4:C$86=$B4);1));"");IFERROR(INDEX(Orario!$A$4:$A$78;AGGREGATE(15;6;ROW($1:$100)/(Orario!C$4:C$86=$B4);2));"");IFERROR(INDEX(Orario!$A$4:$A$78;AGGREGATE(15;6;ROW($1:$100)/(Orario!C$4:C$86=$B4);3));""))

I am able to translate the info on sheet 1 to sheet 2.

date date date
name place1 place3 place1
name2 place2 name1 place2

I would like to have another sheet with this setup also only reading

Name name name
date place1 place3 place1
date place2 name1 place2

I would like that if I change something in 1 to be updated in sheets 2 and 3 . While now sheet 2 is updated if I try to transpose sheet 2 in 3 never updates and if i use some method I found on the internet for linking the trasposed data from 2 to 3 Excel hangs in a very long computing time for every change I made.
here my timetable file Orario V25 Forum delist.xlsm

I am a total beginner please excuse me if I asked something the wrong way.
Andrea