Bid Levelling


I need to create a solution to analyze bids received and award a contract. I'm hoping this is possible through Smartsheet, however, have not yet been able to cobble together a solution.

I have 3 separate worksheets titled 'GC #1 Bid', 'GC #2 Bid', 'GC #3 Bid'.

Ideally I would like to have 1 worksheet with each bid in separate columns;

Any thoughts on how I might accomplish this in a fairly automated manner? I realize that I could 'copy' each column from the individual sheets and paste into the 'Bid Levelling' sheet, however I anticipate having many situations for different team members where this action will be wanted.

Best Answer