I'm trying to link info from one tab to another. Here we go again. I hope I
am clear with the example:

Sheet 1: Column A Column B Column C
Building 1 $1,000 Blue
Building 2 $2,000 Red

Sheet 2: would be linked to sheet 1 and would look like this:

Column A Column B
Building 1 $1,000
Building 1 Blue
Building 2 $2,000
Building 2 Red

I have about 500 lines and to manually do each row would take time. If it
can't be done, let me know so that I can move on.

THANKS