Linking Data Trouble

[Maddehn]

I've taken classes, but until now, I have not used Excel in any job function. I have this i need to work out in order to create inspection records.
I'm looking to link data from one Excel sheet to another. My destination sheet has hundreds of rows of information with about 10 headers(columns). What i want to do is insert a function to grab information from my different reference sheets and put them right in the middle of said rows, but I'm having trouble adding in the needed rows(from reference sheet). Please keep in mind that some of these reference sheets will be updated with more rows, which in turn need to be updated into my destination file. So what i need is a formula, or reference to grab the required information and add in how ever many rows of that said information into my destination sheet. The destination sheet will also have to be linked to the reference sheets, as the destination sheet has to auto-update with any new information from the references.

I know this seams to be an access project, but my current employer wants to try it this way. This may be a simple fix to any of you, but for me its driving me nuts.

Any help would be greatly appreciated.

[mrice]

Your challenge appears to be similar to one which appeared on the forum a few days ago.

http://www.excelforum.com/excel-prog...ing-macro.html

Maybe the same solution is appropriate?