How to pull data from all sheets into a master sheet (for accounting purposes)

%3CLINGO-SUB%20id%3D%22lingo-sub-2024893%22%20slang%3D%22en-US%22%3EHow%20to%20pull%20data%20from%20all%20sheets%20into%20a%20master%20sheet%20(for%20accounting%20purposes)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024893%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20we%20have%20a%20construction%20company%20and%20we%20keep%20all%20of%20our%20job%20data%20in%20a%20workbook%2C%20separated%20out%20by%20job%20(a%20sheet%20for%20each%20one).%20We%20have%20gross%20revenue%2C%20net%20profit%2C%20taxes%20etc.%20on%20each%20sheet.%20I%20want%20to%20put%20a%20sheet%20in%20the%20front%20that%20will%20pull%20specific%20cells%20from%20each%20of%20the%20other%20sheets%20and%20list%20the%20data%20in%20columns%20so%20we%20can%20have%20an%20accurate%20view%20of%20our%20cash%20flow%20in%20and%20out%20of%20the%20company.%20The%20sheets%20are%20labeled%20by%20the%20jobsite%20address'%20currently%2C%20with%20a%20template%20sheet%20in%20the%20front.%20I%20plan%20to%20put%20create%20an%20accounting%20sheet%20before%20the%20template%2C%20all%20other%20sheets%20will%20be%20one%20for%20each%20job.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20If%20so%2C%20how%20would%20I%20go%20about%20doing%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20help%20you%20can%20provide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2024893%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025179%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pull%20data%20from%20all%20sheets%20into%20a%20master%20sheet%20(for%20accounting%20purposes)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025179%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Sir%2C%3C%2FP%3E%3CP%3EI%20can%20solve%20your%20issue%20but%20for%20that%20can%20you%20please%20contact%20me%20on%20my%20mail%20ID%20jdevendra6509%26nbsp%3B%40%20gmail.com%20for%20details%20.%20Please%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915125%22%20target%3D%22_blank%22%3E%40iBretish%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025377%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pull%20data%20from%20all%20sheets%20into%20a%20master%20sheet%20(for%20accounting%20purposes)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915125%22%20target%3D%22_blank%22%3E%40iBretish%3C%2FA%3E%26nbsp%3BAs%20an%20accountant%20myself%2C%20I%20would%20start%20collecting%20all%20transactional%20data%20in%20a%20real%20accounting%20system%20and%20from%20there%2C%20pull%20information%20by%20project%2Fjob%20site%20into%20Excel%20and%20do%20whatever%20analysis%20the%20accounting%20system%20can't%20do%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20you%20want%20to%20do%20the%20exact%20opposite.%20Collect%20data%20by%20project%2Fjob%20site%20in%20Excel%20and%20then%20put%20that%20back%20into%20an%20accounting%20system.%20If%20you%20could%20share%20an%20example%20workbook%20with%20some%20anonymised%20dated%20for%20some%20projects%2C%20it%20would%20be%20easier%20to%20put%20you%20in%20the%20right%20direction.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 put a sheet in the front that will pull specific cells from each of the other sheets and list the data in columns so we can have an accurate view of our cash flow in and out of the company. The sheets are labeled by the jobsite address' currently, with a template sheet in the front. I plan to put create an accounting sheet before the template, all other sheets will be one for each job.

 

Is this possible? If so, how would I go about doing this? 

Thank you for any help you can provide.

2 Replies

Hello Sir,

I can solve your issue but for that can you please contact me on my mail ID jdevendra6509 @ gmail.com for details . Please @iBretish 

@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.