Assuming that Master is a table in you DB:

USE [TrackIT]

GO

INSERT INTO [dbo].[tblTransactions]

(tblTransactions.Buyer_Initial,

tblTransactions.HeatTicketNumber,

tblTransactions.PO_Number,

tblTransactions.Transaction_Date,

tblTransactions.EndUserFirstName,

tblTransactions.EndUserLastName,

tblTransactions.EmployeeStatus,

tblTransactions.CostCenter,

tblTransactions.TermDate,

tblTransactions.License_Available,

tblTransactions.TransferFrom,

tblTransactions.TransferTo,

tblTransactions.EndUserLocation,

tblTransactions.EquipType,

tblTransactions.Quantity,

tblTransactions.Software_Description,

tblTransactions.Notes,

tblTransactions.Unit_Price,

tblTransactions.AllocationDate,

tblTransactions.Last_Renewal_Date,

tblTransactions.NextRenewalDate,

tblTransactions.LastRenewalPO,

tblTransactions.Transaction_Number)

Select

Master.Buyer_Initial,

Master.HeatTicketNumber,

Master.PO_Number,

Master.Transaction_Date,

Master.EndUserFirstName,

Master.EndUserLastName,

Master.EmployeeStatus,

Master.CostCenter,

Master.TermDate,

Master.License_Available,

Master.TransferFrom,

Master.TransferTo,

Master.EndUserLocation,

Master.EquipType,

Master.Quantity,

Master.Software_Description,

Master.Notes,

Master.Unit_Price,

Master.AllocationDate,

Master.Last_Renewal_Date,

Master.NextRenewalDate,

Master.LastRenewalPO,

Master.Transaction_Number

from [Master]

GO