Adding Daily Expense to Tracking Spreadsheet by pulling data from Trial Balance

Hi can anyone help providing me the VBA code to extract data from trial balance and adding the expense to day1 to day31 column in a consolidated spreadsheet. Ken_555