Trying to copy one column determined by input

Hello,

i have one master work book with 70 sheets and i need to copy specific columns from other spreadsheets with the same sheet names and count to the corresponding sheet and columns in the master sheet. for example the user would have the master spreadsheet A and another spreadsheet B open. the user would be prompted for the column, and they would type say "BG" then all columns "BG" from each worksheet from spreadsheet B would copy to the corresponding sheets of workbook A in column "BG". any help would be appreciated