have information from different people and want to consolidate it in one
single sheet using pivot tabel (without using macro)

sample-

Data - 1

Name Date Org Status Tiff #
Anita 14-Apr-10 it processed 123
Anita 14-Apr-10 it pending 126
Anita 15-Apr-10 datex pending 128

Data 2

Name Date Org Status Tiff
Rahul 14-Apr-10 it processed 131
Rahul 15-Apr-10 datex pending 134
Rahul 15-Apr-10 datex processed 135



it is a continues process day by day

both data are from different excel sheet want it in one sheet