I'm trying to figure out if its possible to write a macro that will take the
value in column 9 of a given row (row will change) and lookup or match it in
a table in a different worksheet named ValidationLists D2:E13, then based on
the information obtained in the lookup open the corresponding tab which is
named the same and located in the same workbook. I'll then have it go on to
make a copy of that tab and fill in additional information from the original
row in the Input tab where it originally started.

I've worked only a little with macros and am just trying to learn a little
of VBA to enhance what I can do with them. Thanks for any suggestions or
direction.