여러 엑셀파일중 원하는 특정 텍스트를 불러오기. 고수님들 도와주세요.

안녕하세요? 엑셀 초보입니다. 업무상 엑셀 기본(그냥 칸 많은 텍스트 작업^^)만 자주 쓰는 편인데 업무상 아래와 같은 작업이 필요하네요. 그래서 고수님들의 조언을 받았으면 해서 담과 같이 질의드립니다.     <A name="[문서의 처음]"></A> 예제) 엑셀 파일  담당A <A name=#6402102d></A> <TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=91 cellSpacing=0 cellPadding=1 width=559 border=1> <TBODY> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 구분</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 가</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 나 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 업무 내역</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38> 경기 34나 1234</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38> 2011. 2. 28. 제출 2011. 3. 1. 준비</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=35> 서울 1가 4567</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=35>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=35>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=35> 2011. 3. 2. 출석</TD></TR></TBODY></TABLE> 엑셀 파일  담당B <A name=#6402102e></A> <TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=87 cellSpacing=0 cellPadding=1 width=559 border=1> <TBODY> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 구분</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 가</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 나 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=17> 업무 내역</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38> 경기 34나 1234</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=38> 2011. 3. 2. 출석 2011. 3. 4. 반송</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=32> 서울 1가 4567</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=32>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=32>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=139 height=32>  </TD></TR></TBODY></TABLE> 질의 드립니다. 위 양식의 파일이 여러개입니다. 양식은 같은데 담당자 별로 맡은 업무에 대해 정리를 하다보니 파일이 보통 5-10개 정도입니다. 위 파일들에는 날짜별로 앞으로 해야할 일들이 기재되는데 이를 근거로 해서 아래와 같은 공동 사용 일정표를 만들고 싶습니다. <A name=#6402102f></A> <TABLE style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" height=123 cellSpacing=0 cellPadding=1 width=578 border=1> <TBODY> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=172 height=28> 3월 1일 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=179 height=28> 3월 2일 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=77 height=28> 3월 3일</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28> 3월 4일</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28> 3월 4일</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=172 height=38> 담당A,경기34나 1234 준비</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=179 height=38> 담당B 경기34나 1234 출석 담담A 서울1가4567 출석</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=77 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=38>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=38>  </TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=172 height=28> 3월 5일 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=179 height=28> 3월 6일</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=77 height=28> 3월 7일</TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28> 3월 8일 </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28> 3월 9일</TD></TR> <TR> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=172 height=28>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=179 height=28>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=77 height=28>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28>  </TD> <TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid" vAlign=center width=74 height=28>  </TD></TR></TBODY></TABLE>  각 날짜에 해당하는 텍스트 내용을 일정일(해당일) 란에 자동으로 불러 오는 작업이 가능할가요? 즉 3월 1일의 일정이 있는 각 담당자 파일들을 검색해서 몇 가지 텍스트를 불러오는 기능인거죠.   고수님들이 도와주세요.