Macro to pull data from workbooks and return double sided accounting entry

This is my first post so I am sorry if I making any mistakes in etiquette.

Anyway I have an excel workbook with about 200 worksheets. Every workseheet contains a report like this:



Capture1.PNG

For every value in Columns E,F,G,or J there would need to be an entry in a row in this format: Date-GL-Fund#-Department-project-$amount. There would then need to be an offsetting entry. This template would populate like this, notice that the signs are reversed:

Capture2.PNG

In the end everything zeros out.

There are about 200 worksheets like this. The number of records will vary and the Fund # will be different in each fund.

Does anyone have any suggestions, resources or macros that would be useful?