Automatically updating a spreadsheet from another spreadsheet - Microsoft Community

i pretty novice in excel need use internship.

i have excel workbook that:

• (worksheet 1) updated , sent me every month (includes names , other information )
• (worksheet 2 & 3) supplementary material first worksheet , never changed.

i need figure out how update worksheet 1 (there names go through names , delete isn't there anymore , add needs added) automatically when sent every month using pivot tables or query. overall want able open 1 file , have worksheet 1 , supplementary material , have worksheet update whenever new spreadsheet sent me automatically not have go on manually.

hi,

for clear idea excel query, we'd request sample copy of worksheet , possible outcome like.

let's sort out. we'll waiting response.

Office / Excel / Windows 10 / Office 2016