Compiling Multiple Sheet Contents into one Sheet
 

I have a series of files (one per user), all of which contain data in
multiple tabs. I'd like to consolidate all of the data across these
files in their respective "Discons" tab.

Each tab is designed the same:
B C D E F
Name ID1 ID2 Description Date

Is there a way to have a macro/update button to pull all of the
contents from the "Discons" tab from all of these files into one tab of
the same structure (B through F) in the Master File? Thanks for your
help.


---
Message posted from http://www.ExcelForum.com/

Compiling Multiple Sheet Contents into one Sheet
 

I'd appreciate any help anyone can giv

--
Message posted from http://www.ExcelForum.com