dynaimcally organizing or copying cells?

[Mike H]

I have a workbook with eight tabs. The first tab is just a sequence of data,
A2:A61.

There are three columns, Item, Description, and Tab.

Rather than doing a lot of copy/pasting, I'd like to be able to put a number
in the tab column and have the other two entries copied to the next available
row in the associated tab in the workbook. This way, I can go down the
column entering tab number and quickly sort and assign the data to where it
belongs.

Any suggestions? Can it be done without any serious programming?

 

[Dave Peterson]

It sounds like =vlookup() or =index(match()) would work:

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))