Consolidating data from multiple worksheets

Originally Posted by K m

See the attached worksheet

Hi,

I'm looking for something cleaner and more user friendly since the actual data I have is massive with more than 10 different spreadsheets and more headlines. Is there any way to have a form/table that extracts data from separate spreadsheets? For example, it would show only unique items under each of the headlines instead of combining them all in one

Thanks a lot,
Ann