Forum Discussion
How to pull data from all sheets into a master sheet (for accounting purposes)
So we have a construction company and we keep all of our job data in a workbook, separated out by job (a sheet for each one). We have gross revenue, net profit, taxes etc. on each sheet. I want to pu...
iBretish As an accountant myself, I would start collecting all transactional data in a real accounting system and from there, pull information by project/job site into Excel and do whatever analysis the accounting system can't do for me.
It seems you want to do the exact opposite. Collect data by project/job site in Excel and then put that back into an accounting system. If you could share an example workbook with some anonymised dated for some projects, it would be easier to put you in the right direction.