Excel VBA Macro Fix Required

We have a macro in one of our Excel spreadsheets (Office 365) that is not functioning correctly. The macro imports all the data from one tab of spreadsheet B into a tab of Spreadsheet A, and moves/formats the required information in sheet A into another tab, combining incoming stock numbers and dates. We need a VBA expert to modify our existing macro so it works correctly. It should be quite a quick fix for someone with the right knowledge of VBA.