@_Asif_ 's solution will work with the data you provided although I would have used
UNION instead of
UNION ALL (the net effect is the same because there cannot be duplicates due to the tablename column).
But it's worth pointing out that if there are records in more than 1 of the tables that match the minimum value then you will get multiple rows for that name and value e.g. with
declare @TabAnaOra2 table (Var1 decimal(6,3), Var2 decimal(6,3), [Name] varchar(30));
insert into @TabAnaOra2 (Var1, Var2, [Name]) values
(0.77,35.00,'francesco')
,(0.25,41.02,'jhon')
,(70 ,8.002,'julia');
declare @TabAnaOra3 table (Var1 decimal(6,3), Var2 decimal(6,3), [Name] varchar(30));
insert into @TabAnaOra3 (Var1, Var2, [Name]) values
(0.03, 28.00,'rudolf')
,(0.25, 15.02,'jhon')
,(100 , 0.102,'julia');
you would get
Name MinVar1 MaxVar1 TableName TableName
francesco 0.130 0.770 TabAnaOra4 TabAnaOra2
jhon 0.250 125.000 TabAnaOra2 TabAnaOra4
jhon 0.250 125.000 TabAnaOra3 TabAnaOra4
julia 10.000 100.000 TabAnaOra1 TabAnaOra3
maria 10.220 10.220 TabAnaOra4 TabAnaOra4
rudolf 0.030 0.030 TabAnaOra3 TabAnaOra3
So you may want to consider a 2nd temporary table to resolve that issue e.g.
DECLARE @TmpTable2 TABLE
(
Var1 decimal(6, 3),
Var2 decimal(6, 3),
Name varchar(20),
Tab1 varchar(50),
Tab2 varchar(50)
);
INSERT INTO @TmpTable2
SELECT T.MinVar1, T.MaxVar1, T.[Name], T1.TableName as Tab1, T2.TableName as Tab2
FROM
(
SELECT Name, min(var1) as MinVar1, max(var1) as MaxVar1
FROM @TmpTable T
GROUP BY Name
) T LEFT OUTER JOIN @TmpTable T1 ON T.Name = T1.Name AND T.MinVar1 = T1.Var1
LEFT OUTER JOIN @TmpTable T2 ON T.Name = T2.Name AND T.MaxVar1 = T2.Var1
SELECT [Name], Min(Var1) as MinVar1, Max(Var1) as MaxVar1, Max(Tab1) as Tab1, Max(Tab2) as Tab2
from @TmpTable2
GROUP BY [Name];
The real question is why use such an awful database design - four tables, all with the same schema and all with similar data looks prime for a single table with an extra column to indicate source (for example). Far more extensible design and your queries will be a lot simpler too