Macro to Copy, transpose paste into master worksheet as apart of a table ?

[northernwarrior]

Hi All,

So I was wondering if I have a workbook that has a scorecard a team lead fills in. Once that is completed, I'd like to have a button on the sheet that would copy Column B contents to a master workbook as a transpose paste that would add the row to the bottom of the table.

Master workbook would be on a shared drive and the scorecard would most likely be on the team leads computer.

Is this possible ?